How to Shrink the IM Manager Database Transaction Log on SQL Server and MSDE

Article:TECH86475  |  Created: 2006-01-08  |  Updated: 2011-10-05  |  Article URL http://www.symantec.com/docs/TECH86475
Article Type
Technical Solution

Product(s)

Issue



You have determined that the IM Manager database transaction log is taking a significant amount of space.  You have determined, based on your backup and data retention policies, that you would like to reduce the size of the transaction log.




 


Solution



Below are instructions for truncating the SQL Server Transaction log. This information is provided "as is". If you have trouble shrinking your SQL Server transaction log, please work with your DBA group or Microsoft to resolve this issue.
 

SQL 2000
 

Here is one way to shrink the transaction log for SQL Server 2000:

1.      Open Enterprise Manager

2.      Right click on the IM Manager database and select All Tasks > Backup Database.

3.      Select Transaction log backup.

4.      Back up the transaction log.

5.      When finished, right click on the IM Manager database and select All Tasks > Shrink Database'.

6.      Select Files.

7.      Select the transaction log file from the drop down.

8.      Select the Shrink Action of Truncate Free Space from the end of file.

9.      Click OK.


At this point, the transaction log is shrunk.

Please see this Microsoft KB for more information on how to shrink the transaction log for SQL Server 2000.
http://support.microsoft.com/kb/272318/EN-US/



SQL 2005

 

1.   Open Microsoft SQL Server Management Studio.

2.   Right click on the IM Manager database and select Tasks > Shrink.

3.   In File Type, select "Log" in the drop-down list

4.   Click OK.
At this point, the transaction log is shrunk.

Please see this Microsoft KB for more information on how to shrink the transaction log for SQL Server 2005.
http://support.microsoft.com/kb/907511

 

 MSDE

1. Download the attachment MSDE_Shrink.zip.

2. Run the batch file by either double-clicking it or running it directly from the command line.

3. The tool will prompt the user for the password to the IM Manager's MSDE database. The tool will shrink the Transaction log and place the results in a file called 'output.txt' in the same directory the tool is located in.
 

 





 

 


Attachments

MSDE_Shrink.ZIP
MSDE_Shrink.zip (769 Bytes)


Legacy ID



2007391511887398


Article URL http://www.symantec.com/docs/TECH86475


Terms of use for this information are found in Legal Notices