Shrinking Log File - SQL Server Forums

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)

Shrinking Log File

Author

Topic

thugs
Starting Member

13 Posts

Posted - 2007-09-10 : 09:57:52

Hi,

Got a problem with shrinking of log file
My database is on Development server
Data file size : 89 MB
Log File Size : 1.3 GB

First i ran the DBCC SHRINKFILE after that there is no change in the size of the log file
then i took the log fikle backup and tried to shrink using the DBCC SHRINK file still no change in the size
Again i took the log backup and ran DBCC command but there is no use

Can anyone help me out in this

thanks,

Kristen
Test

22859 Posts

Posted - 2007-09-10 : 10:55:27

"then i took the log fikle backup"

Did you use this?

backup log MyDatabaseName with truncate_only

See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Why+is+my+LDF+Log+File+so+big,Database%20Shrinking,Shrinking,Shrink

Take a FULL backup once you have done the Shrink, and beware that doing Shrink other than for a one-off cause will adversely effect performance.

Kristen