Open command window
Change directory to 'C:\Program Files\Microsoft SQL
Server\80\Tools\Binn'
Enter 'sqlservr -m -T 3608' to start SQL Server with minimum
configuration
Right click master
Select all tasks
Select restore database...
On the General tab make sure that the Restore as database: box shows
"master" for the DB name
Next select the radio button for From Device: , click the Select Devices
button
Click on the Add button, browse for the file by clicking the ... button
Locate and select the master database restore file, click OK, click OK
again to return to the "Choose Restore Devices", click OK again to
return to the "Restore Database" box
Click the Options Tab sheet
Click to check the box next to "force restore over existing database"
IF necessary you can select a different location to restore the files to
by editing the "Move to physical file name" section of the dialog box.
Ensure the "Leave Database Operational" radio button is selected
7. Stop SQL Server by hitting CTRL 'C' in command window. Enter 'y'
to shutdown SQL when asked
Ivan
-----Original Message-----
From: Anthon Mark J - DOA
[mailto:mssqldba-ezmlmshield-x91579738.[Email address protected]
Sent: Thursday, June 29, 2006 1:40 PM
To: LazyDBA Discussion
Subject: Restoring Master
It's been awhile since I or my colleagues have restored Master (SQL
Server 2000) and wondered if anyone has the steps handy. Otherwise I'll
go slog through MS and find it.
Thanks Much,
Mark
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
******************NOTICE*******************
This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s) only and may contain privileged, confidential, work-product and/or trade secret information of a proprietary nature. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use, distribution or re-transmission of this e-mail or any attachment(s) is strictly prohibited and that all rights of the sender and/or intended recipients are hereby reserved without prejudice thereto.
MS Sql Server LazyDBA home page