Grass Valley NewsBrowse Desktop Browsing System Installation v.3.1 - Manual (Page 121)

April 27, 2006 NewsBrowse Installation and Configuration Guide 121
Manually controlling transaction log growth
Manually controlling transaction log growth
Use this procedure when the transaction log is approaching its size limit. First back
up the database and the transaction log to keep a record of its current state. Then flush
and shrink the transaction log file to reduce its size. To do this open SQL Enterprise
Manager and manually backup the database and transaction log of the database in
question. The steps to do this are as follows:
Back up the transaction log
The following procedure uses the default location of the transaction log backup,
which is as follows:
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\\
If your transaction log backups are in a different location, substitute the different path.
1. Open Start | Programs| Microsoft SQL Server | Query Analyzer .
2. Connect to the SQL Server which is hosting the NBIngest and MediaFrame
databases. An empty query automatically opens.
3. To back up the transaction logs, type the following commands. In these examples
the number string at the end of the command indicates May 31, 2005 at 12:00.
Enter the actual year, month, date, hour, and minute in the indicated
YYYYMMDDHHMM format.
• To back up the NBIngest transaction log, type:
BACKUP LOG NBIngest
TO DISK=’C:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\NBIngest\_tlog_200505311200’
• To back up the MediaFrame transaction log, type:
BACKUP LOG MediaFrame
TO DISK=’C:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\MediaFrame\_tlog_200505311200’
4. Continue with the next procedure “Shrink the transaction log” .
Shrink the transaction log
This must be done very soon after backing up the transaction log. This will reduce the
transaction log to the size specified; the log will then grow as needed.
Use Query Analyzer, as in the previous procedure.
The command to shrink the NBIngest transaction log file is:
DBCC SHRINKFILE(NBIngestLog, 10)
The command to shrink the MediaFrame transaction log file is:
DBCC SHRINKFILE(MediaFrameLog, 10)