restore master DB - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

restore master DB

Author

Topic

kumarich1
Yak Posting Veteran

99 Posts

Posted - 2009-10-22 : 10:32:53

I am trying to gather information on How I can restore master DB in case of Disaster? I looked BOL , but could not successfully perform the task. Can anyone please suggest steps that I should follow in restoring master DB. I will try the steps in my test server.

Thanks in advance

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-10-22 : 13:05:52

What do you mean you "could not successfully perform the task"? Did you get an error and if so on what step?

What is described in BOL is how you restore it, so we wouldn't be providing any different information.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

abidba
Starting Member

26 Posts

Posted - 2009-10-22 : 15:17:48

Kumaruich1:
You can use use the Rebuild Wizard (Rebuildm.exe) to recover your curropted master database.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources