Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 252
  • Last Modified:

Master Database Log Backup Question

Hi Everyone,

I have a master database for which I was checking the:   log_resuse_wait_desc  column. in the sys.databases table.

The Master database always has the entry LOG_BACKUP for the column. (I am using SQL Server 2008)

I didn't notice this at all on SQL Server 2005. In fact, I still have a couple of databases that are 2005.

My question is:  Is this normal?  

My Recovery Model is Full and I can only take full Backups for the master database (No differential or Transaction Log backups are allowed). Usually, for any other database the way to remedy the situation is to do a Transaction Log backup, but that is not allowed.

Thanks Again,
0
jonsuns7
Asked:
jonsuns7
1 Solution
 
JaseemKCommented:
Please see article below for information. It may help.
http://msdn.microsoft.com/en-us/library/ms345414.aspx
0
 
David ToddSenior DBACommented:
Hi,

I just checked and Master installed as simple. Are you sure that it is full? Have you restarted SQL since setting Master to full?

HTH
  David
0
 
Anthony PerkinsCommented:
May I suggest that you set the master database back to Simple Recovery Model.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now