Post reply

restoring master database on windows 2000

  • February 10, 2009 at 6:56 pm

    #75410

    Hi Folks,

    how can you restore the master database on a windows 2000 box? (I know how to do it for 2005)

    thanks

  • February 10, 2009 at 9:17 pm

    #941783

    what a task and good luck 🙂

    But from what i remember i had to do it with the (Rebuildm.exe). Cant remember the location of the file but i do know its located within MSSQL. This will completely rebuild your master database. Works very well IF you dont have a current backup of your system databases. You should be up and running in no time at all after your rebuild. 🙂

    Pretty sweet tool the rebuildm is.

    -D

    DHeath

  • February 10, 2009 at 9:43 pm

    #941786

    Do you mean SQL 2000? REbuildm.exe is on the CD and that will help you rebuild a new, baseline, RTM master database.

    If you need to restore, you need to start SQL Server in single user mode, connect with isql or QA and then do a restore.

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

  • February 10, 2009 at 10:32 pm

    #941821

    Oh isql - is that like sqlcmd?

    If so does that mean restoring the master is same as restoring master on 2005 except you use isql instead of sqlcmd?

  • February 10, 2009 at 10:45 pm

    #941835

    yes, isql/osql were the predecessors of sqlcmd.

    You can use Query Analyzer as well, but you can't use the right side object browser since that requires it's own connection.

  • February 11, 2009 at 8:35 pm

    #942588

    thanks Steve.

Viewing 6 posts - 1 through 5 (of 5 total)

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