Monday, February 20, 2012

reduce log file

I want to reduce my log file. it was 64 gb the other day. I deleted it and
recreated another log file.
What is the correct way to use the shrink file command?
mdb
mdb
http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
and AutoShrink
http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
Server 7.0 Tran Log
http://www.support.microsoft.com/?id=272318 INF: Shrinking Log in SQL
Server 2000 with DBCC SHRINKFILE
http://www.karaszi.com/SQLServer/info_dont_shrink.asp Shrinking
considerations
Andrew J. Kelly SQL MVP
"mdb" <mdb@.discussions.microsoft.com> wrote in message
news:87373855-6995-4660-930F-FAE61DF3650E@.microsoft.com...
> I want to reduce my log file. it was 64 gb the other day. I deleted it
and
> recreated another log file.
> What is the correct way to use the shrink file command?
>
> --
> mdb
> --
> mdb

No comments:

Post a Comment