Master Database Log Backup Question

Posted on 2011-05-05
Last Modified: 2012-05-11
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,
Question by:jonsuns7
    LVL 3

    Expert Comment

    Please see article below for information. It may help.
    LVL 35

    Accepted Solution


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

    LVL 75

    Expert Comment

    by:Anthony Perkins
    May I suggest that you set the master database back to Simple Recovery Model.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This video discusses moving either the default database or any database to a new volume.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now