master db backup failed

  • master db backup failed? we need to rebuild that.How to rebuild master database in proper way

  • Hi There,

    I don't really understand what it is that you are trying to do. Is it the backups which are failing, if so what are the errors or is your master database which is corrupt?

    ============================================================
    David

    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • What error is the backup failing with?

    Why do you think you need to rebuild master?

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • If you have lost the database or it's been corrupted and you don't have a backup available, you'll have to rebuild the database. Microsoft has documentation on how to do that.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • There are no direct relation between master backup failed and rebuild master.

    Have you checked why master backup is failing? Rebuilding the master is not a solution.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply