Grass Valley Aurora Browse v.6.5 Installation - Manual (Page 108)

108 Aurora Browse Installation and Configuration Guide November 1, 2008
Chapter 4 Recovery Planning
Shrink the transaction log
After backing up the transaction log, you must flush and shrink the transaction log file
to reduce its size. This must be done very soon after backing up the transaction log.
1. If it is not already open, open Microsoft SQL Server Management Studio and log in
with the appropriate credentials. To create or manage maintenance plans, you must
be a member of the sysadmin fixed server role.
Server Management Studio opens.
2. Select New Query , and change the selected database to MediaFrame .
3. Run the following command:
DBCC SHRINKFILE(MediaFrame_Log, 10)