[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).

You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610