maandag, september 04, 2006

Reattaching the MASTER DB in SQL Server

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.

Geen opmerkingen: