The backup of the master database that you are restoring is not usable.
Then select the location where the backup resides. If the user databases were part of replication then Start the sql server services from sql server configuration manager or from services in administration tools. Ignore this and close the management studio. After the restore is completed,Įrror message will be displayed. Now log on sql server management studio and restore the master database from backup. generally it will be in D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn) Sqlservr.exe -m ( Need to change directory to location where sql server was installed.
Start /wait setup.exe /qn INSTANCENAME= REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=Īgain stop the sql server services and bring up the instance in single user mode by executing Then run the command after changing to location where sql server media exists Go the sql server configuration and change the properties to startup manual and stop the sql server services This point to the location from where the sql server 2005 was installed from. The location can be found from SQLSetup001_ _SQL.log ? Search for Product in this log file. SQL SERVER 2005 install media should be restored to the same location from where sql server was installed originally. Here are the instructions on how to rebuild master database. For other options, please see the above link, which points to “How to: Install SQL Server 2005 from the Command Prompt”. The REINSTALMODE=o (letter Oh, not zero) indicates to setup that I want it to “Reinstall if the file is missing or if it is an older version”. The main issue I had (and which you probably have) is that the SQL Server has been upgraded to SP1 and I was restoring an earlier version of the system databases, which setup was not in favour of. Under the chapter, “To repair all files, rebuild the registry, and replace all SQL Server shortcuts from the command prompt”. The operative command is REINSTALLMODE, which is hidden in the depths of Start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=mypassword REINSTALLMODE=omu I had to recreate all system databases as part of a DR exercices, on a machine that had just the system & user backups and a restore of the filesystem.Īfter a lot of headscratching and trying this and that, the following worked a treat:
0 kommentar(er)
