Tuesday, August 27, 2013

[MS SQL Server] Do we have possibility to update system tables in SQL..

[MS SQL Server] Do we have possibility to update system tables in SQL..

Do we have possibility to update system tables in SQL..

Posted: 26 Aug 2013 05:43 PM PDT

Can i have one clarification on system tables for SQL, Is it possible to update system tables in SQL server... Please help me out here !!!!

LOG_BACKUP status not clearing in sys.databases

Posted: 27 Aug 2013 12:29 AM PDT

SQL Server 2008R2 SP2 Does anyone know how to resolve this?When I view sys.databases on one of our servers, I can see two databases that have "log_reuse_wait_desc" status of LOG_BACKUP.But however many times I run backup log, this message does not clear.BACKUP LOG [GHLPLAY] TO DISK=N'G:\Logs\GHLPLAY_Log.bak' WITH NOINIT, SKIP, STATS=20, NAME=N'GHLPLAY Log'BACKUP LOG [GHLPLAY] TO DISK=N'G:\Logs\GHLPLAY_Log.bak' WITH NOINIT, SKIP, STATS=20, NAME=N'GHLPLAY Log'select name n,recovery_model_desc,log_reuse_wait_desc lrwd,* from sys.databaseswhere name like 'GHLPLAY'=> returnsn recovery_model_desc lrwdGHLPLAY FULL LOG_BACKUPIt is not (as far as I know) causing any issues but it is a little concerning.I don't know if this is of any relevance but one of the two databases is the only mirrored database on the server – but is currently static (not being used).
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog