Posts tonen met het label SQL Server. Alle posts tonen
Posts tonen met het label SQL Server. Alle posts tonen

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.