November 25, 2002 at 2:34 am
I have a scenerio.....
master database is on d: and Sql server 2k is on c:
D drive got corrupt and sql is not coming up
How to start sql server and restore master database?
I am having master database backup and know the procedure to move it to new location change commandline parameters for sqlserver.exe, by defining path to dat and log files. In this case i am having only backup not having dat and log file??????
Thanks....
Prakash
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
November 25, 2002 at 5:39 am
If you completely lost the master and have only a backup then you will have to do a reinstall. Then you will need to start the new install in single user mode.
From BOL
quote:
How to start the default instance of SQL Server in single-user mode (Command Prompt)To start the default instance of SQL Server in single-user mode from a command prompt
From a command prompt, enter:
sqlservr.exe -c -m
Note You must switch to the appropriate directory (for the instance of Microsoft® SQL Server™ you want to start) in the command window before starting sqlservr.exe.
Then you can do your restore, see BOL for more detail by looking at RESTORE and look for the item on restoring the master backup.
November 26, 2002 at 12:38 am
Thanks..Antares686
If i do the reinstall of sql server than my existing databases will not get affected. right?
Prakash
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
December 2, 2002 at 6:00 am
It will reinstall new copies of the system databases. For safety I usually copy or move all existing databases to another location. Then reinstall, stop sql. Move the files back, start SQL in single user, restore master, stop SQL, restart SQL in normal mode. As long as you do not change the data location there should be no issues. If you are not installing the master to the same location then you may need to delete the new system DBs it created since they will not be used once the master is restored.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply