Shrinking transaction log on MS SQL server 2000/x
(Please call Eirik Simonsen at 561.272.8690 if there are any errors in this document or
mail to : es@nteraction-crm.com
AS A GENERAL RULE, IT IS GOOD POLICY TO DO A BACKUP BEFORE YOU DO ANYTHING WITH A DATABASE – THIS IS NO EXCEPTION.
Start Enterprise Manager, Choose Microsoft SQL servers => (local)(Windows NT) => databases. Right click on the database => all tasks => detach database.
If user are logged on the database, enter clear for these to be evicted. After this the ok button will become enabled. Choose OK – PS: I always suggest that you ask them to log out, rather than simply throw them out
Then, delete the database transaction file. This is, if default installation path have been used located in Driveletter:\Program Files\Microsoft SQL Server\MSSQL\Data , and is named SuperOffice.ldf, (if the database name is SuperOffice that is)
Then go to enterprise manager and again right click on databases => all tasks => attach database. Browse to the SuperOffice.mdf file, This is usually located in Driveletter:\Program Files\Microsoft SQL Server\MSSQL\Data. Select OK.
SuperOffice can then be used, and the transaction log should be considerably smaller