hi,
I use a sql server 2000. My log file size is too larger around 9gb .how can i squeeze it .
thankx,
faraz
Loading
hi,
I use a sql server 2000. My log file size is too larger around 9gb .how can i squeeze it .
thankx,
faraz
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Mahesh ChandPosted Aug 6, 2008, 6:49 AM
Try using SHRINKFILE.
USE
DatabaseNameGO
DBCC SHRINKFILE(<TransactionLogName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<TransactionLogName>, 1)
Also, here is some reading on shirinking a log file:
http://bloggingabout.net/blogs/mglaser/archive/2007/01/12/sql-server-tip-shrinking-a-sql-server-log.aspx