Post reply

how to restore database when the whole database is crashed including Master database

  • January 29, 2007 at 4:41 am

    #172008

    Good morning,

    Thank you Very Much

    but the bad thing is i dont have the Master Database BackUp

    Mr.Robert

    Mr.JBstyle

    Mr.brian Kelley

  • January 29, 2007 at 5:18 am

    #686107

    you need to be a little more specific, the term "crash"  means nothing.

    • Do you have backups
    • do you have intact mdf files
    • what caused your problem

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • January 30, 2007 at 11:27 am

    #686555

    If you have lost the server but you have backups, you will first need to get another server with SQL Server installed, then you will need to restore the lost databases from backups (.bak & .trn files).  You can use the instructions on Books online ..> Backing Up and Restoring Databases.  With this process a new Master is created so you will lose all jobs, Maintenance plans and DTS Packages. 

    If you have a backup of the Master database you can follow the procedure to first rebuild the Master database on Books online --> "How to rebuild the master database (Rebuild Master utility) " then restore the other databases.  If you are able to rebuild the Master you will not lose jobs, DTS packages, etc.

  • January 30, 2007 at 7:47 pm

    #686678

    I'm going to have to piggy-back on Colin:

    what caused your problem

    That's a really important question as it helps determine the right answer. Also, if you haven't solved the problem (i.e. bad hardware which is flaky), you're going to likely find yourself back in this same mess.

     

    K. Brian Kelley
    @kbriankelley

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

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