Wednesday, March 28, 2012

Log Full

I am having a problem with one of my databases since the log is getting
rather large dispite regular back up. I have heard that there a extended
stored proceedure that will recycle the log. Anyone have an idea..?
I really appreciate this."Recycle The Log" is a term used when talking about the SQL Server Errorlog.
The command in question is sp_cycle_errorlog. To view it use
sp_readerrorlog.
However, neither of these are any good to you as the log you are refering to
is the TransAction Log. There are numerous articles on the subject, here are
a few :-
http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
Server 7.0 Tran Log
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=272318 INF: Shrinking Log in SQL
Server 2000 with DBCC SHRINKFILE
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
--
HTH. Ryan
"bluefish" <bluefish@.discussions.microsoft.com> wrote in message
news:32533A4B-FC3A-4536-BD99-BD9BEFEAA1C9@.microsoft.com...
>I am having a problem with one of my databases since the log is getting
> rather large dispite regular back up. I have heard that there a extended
> stored proceedure that will recycle the log. Anyone have an idea..?
> I really appreciate this.
>

No comments:

Post a Comment