question

Therealist avatar image
Therealist asked

How to rebuild and restore the master database without a backup file ?

Hi how to rebuild and restore master database without backup, could someone provide me with the steps to be followed, as i am aware of restoring the master database with a backup file using CMD and SQLCMD. Thanks in Advance
rebuildsystem-databasesmaster
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
If you have a corrupt master database and no backups, you are in trouble and you have quite some work in front of you. Here's an article which addresses that (and other things). http://www.mssqltips.com/sqlservertip/3266/restoring-the-sql-server-master-database-even-without-a-backup/
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks @Magnus,but i was there and referred that article before posting my question here,but its bit confusing, so i got here wondering if someone could help me with the steps..
0 Likes 0 ·
Restoring a master database is not a trivial thing. Rebuilding a master database without having a backup is even less trivial. To me, the article I posted is pretty thorough. I doubt you can get a better step-by-step-instruction here than that article. I suggest looking for an experienced DBA-consultant to help you out. I know I would. And I would have that consultant hold my hand while I tried to manage it myself.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.