November 26, 2012 at 11:37 pm
Dear,
If I execute the following query,
select name, log_reuse_wait, log_reuse_wait_desc from sys.databases
The result looks alike,
log_reuse_wait|log_reuse_wait_desc
-------------- -------------------
2LOG_BACKUP
Now my query is when does this message appear? Or what does it imply?
Please help me
Regards,
Akbar
November 26, 2012 at 11:57 pm
see this http://msdn.microsoft.com/en-us/library/ms345414(v=sql.105).aspx
and also http://www.sqlservercentral.com/articles/Administration/64582/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 27, 2012 at 12:01 am
shohelr2003 (11/26/2012)
Now my query is when does this message appear? Or what does it imply?
That the log file is not been reused because a log backup is required
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply