Steps needed to follow to restore Master database and other system databases.

Question

Steps needed to follow to restore Master database and other system databases.

SQL_Hunt

SSC-Dedicated

Points: 33518
More actions
July 22, 2010 at 9:59 am

#144196

Hello Friends
Can you please describe the steps needed to follow to restore the MAster databases in SQL Server 2000 and 2005 servers? Also how about the steps to restore the other system databases in SQL Server 2000 and 2005 databases?
Please suggest...
Thanks.

Viewing 9 posts - 1 through 8 (of 8 total)

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

Dan.Humphries SSChampion Points: 12125 More actions · Answer 1

here is a link to an msdn page with step to restore the master database. basically you have to put the database in single user mode and then it is just a typical restore.

http://msdn.microsoft.com/en-us/library/ms190679.aspx

Dan

If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 2

Thanks Dan.

One more query, after taking the SQL Server Instance in Single user mode using -m parameter, if I need to revert it to 'multi user' what is the correct syntax to be used?

Pls suggest ...

Thanks.

Dan.Humphries SSChampion Points: 12125 More actions · Answer 3

The steps are basically.

Stop the service

enter the -m and start the service in single user mode

stop the service

remove the -m

start service normally.

Dan

If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

SQLBalls SSCarpal Tunnel Points: 4621 More actions · Answer 4

Interview Question, Test Question, or do you actually have to do a restore?

Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 5

Hi Bradley B,,

Not sure, whether I need to reply to your response in front of the vast majority of users, however, kindly don't type such kind of questions. This is a 'DBA' forum and everyone has the rights to ask any sort of questions...!

Actually, I have the idea being a DBA, that I can remove the 'm' option to do it, but actually, I was looking for a script to run from the command shell....

By sending such responses, I have noticed few guys increase their points but actually they contribute nothing to the forum!!!

Thanks.

Sudeepta SSCommitted Points: 1666 More actions · Answer 6

Hello Sourav,

Check this link for a detailed steps: http://ukganguly.spaces.live.com/blog/cns!3DBBCE0B87F1CF26!427.entry

Hope, this may help.

Thanks & Regards,
Sudeepta.
http://twitter.com/skganguly

SQLBalls SSCarpal Tunnel Points: 4621 More actions · Answer 7

Sourav-657741 (7/22/2010)
Hi Bradley B,,
Not sure, whether I need to reply to your response in front of the vast majority of users, however, kindly don't type such kind of questions. This is a 'DBA' forum and everyone has the rights to ask any sort of questions...!
Actually, I have the idea being a DBA, that I can remove the 'm' option to do it, but actually, I was looking for a script to run from the command shell....
By sending such responses, I have noticed few guys increase their points but actually they contribute nothing to the forum!!!

1. I did not mean to insut, but understand the need.

2. if you truely need to restore the Master DB then your Database Instance could be offline and your need is critical

3. I did not say you should not post such a question, I am aware of the setting and find your response to be rude

4. The steps posted previously would work for SQL 2005, they would not work for SQL 2000, and if you needed them quickly I would have responded as such.

I'm more than happy to help but generally when someone asks such a question out of need there is a sense of urgency in the post. I did not detect any and wanted to determine how quickly I should respond.

So there ya go, if you need urgent help ask for it, if you don't a clarification would be appriceated.

Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field

SQLBalls SSCarpal Tunnel Points: 4621 More actions · Answer 8

Here is the 1st link that appears on google when you search under "sql 2000 restore the master database"

http://msdn.microsoft.com/en-us/library/aa173515(SQL.80).aspx

it is the MSDN article from Microsoft.

In sql 2000 you must put the database in single user mode using command prompt before you can restore the database.

If you need to repair it then there are additional steps. Here is a very good and detailed article from Steven Warren.

http://articles.techrepublic.com.com/5100-10878_11-5025441.html

Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field