Transaction_log file to shrink

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Transaction_log file to shrink

Author

Topic

shums
Starting Member

1 Post

Posted - 2004-07-29 : 08:22:30

I am using MS-SQL-2000
My database size is 300 MB
But transaction_log file size is 3000 MB (3GB)
I Want to shrink the Transaction_Log file
Please explain how to do this.

Thanks

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-07-29 : 08:30:24

Well, since you obviously aren't doing transaction log backups, you need to set the recovery mode to Simple and shrink the database.

You can set the recovery mode to simple by right-clicking on the database, goingt to properties, going to options, and changing the dropdown to Simple. You need to do this on your model database also.

You can then shrink the transaction log by right-clicking on the database, All Tasks, Shrink Database, Files, select the file in the dropdown that ends with "_log", and hitting OK. There you go.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.