Post reply

Restoring Master Database

  • July 7, 2011 at 8:05 am

    #243713

    Hi All,

    Due to the windows crash we have lost our SQL Server and we have recovered the Databases with re installing SQL and Restoring Databases from backups.

    I have faced one issue during DB restoration.

    I have Installed the SQL Server and decided to restore the master database.

    So i have restarted SQL SErver in Single used mode and started Restoration of Master database.

    till some extent it went fine, it was shown master DB restore successfull and during this SQL services was Stopped.

    i have tried manually to start the services but it failed. I have changed server into multi user mode by removing parameters from start up parameters but no success in starting the SQL Server services.

    Can any one tell me what mistake i have done here?

    So for this i have uninstalled the SQL Server and reinstalled it back and restored the Remaining databases except master. But i have lost logins 🙁

    please let me know what was my mistake in restoring master DB ( i have restored it single user mode)

    I have tried to start the server using NET Start using /3608 it was successful, but dont know what to do after that.

    Thanks all for reading all the story.... 🙂

  • July 7, 2011 at 10:05 am

    #1349803

    Is rebuilding the master database an option available to you?

    [/url]

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • July 7, 2011 at 10:40 am

    #1349831

    Please check the error logs. It's possible you have pathing wrong somewhere, or there is some error being thrown from the services.

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

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