The transaction log for a very small database has shot up to 1G
how do i reduce this, and prevent this happening in the future?
Have a look here:
http://www.nigelrivett.net/Transacti...leGrows_1.html Log File issues
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
"grumy" <grumy@.discussions.microsoft.com> wrote in message
news:CE8FB6F4-8F37-4A39-A7B3-ECBF1D0BC931@.microsoft.com...
> The transaction log for a very small database has shot up to 1G
> how do i reduce this, and prevent this happening in the future?
Showing posts with label 1ghow. Show all posts
Showing posts with label 1ghow. Show all posts
Monday, February 20, 2012
Large log file
The transaction log for a very small database has shot up to 1G
how do i reduce this, and prevent this happening in the future?Have a look here:
http://www.nigelrivett.net/Transact...ileGrows_1.html Log File issues
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
"grumy" <grumy@.discussions.microsoft.com> wrote in message
news:CE8FB6F4-8F37-4A39-A7B3-ECBF1D0BC931@.microsoft.com...
> The transaction log for a very small database has shot up to 1G
> how do i reduce this, and prevent this happening in the future?
how do i reduce this, and prevent this happening in the future?Have a look here:
http://www.nigelrivett.net/Transact...ileGrows_1.html Log File issues
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
"grumy" <grumy@.discussions.microsoft.com> wrote in message
news:CE8FB6F4-8F37-4A39-A7B3-ECBF1D0BC931@.microsoft.com...
> The transaction log for a very small database has shot up to 1G
> how do i reduce this, and prevent this happening in the future?
Subscribe to:
Posts (Atom)