I decided to post a small tutorial on restoring a SQL server by means of the master.mdf database. Here goes:
- Install & stop SQL Server 2000
- Move the master.mdf & mastlog.ldf files to the new location
- Open regedit and go to the following key:
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters
- Adjust the paths in the following screenshot
- Restart SQL Server services
- Done :) All user & system db's should be showing up.
Abonneren op:
Reacties posten (Atom)
Geen opmerkingen:
Een reactie posten