Whenever SQL gives message stating SQL Server not starting and upon trying to restart the SQL Server it denies which indicates the Corruption of Master Database.
As SQL Server is not starting it is not possible to restore the Master database.
To overcome this situation if you have the SQL Server 2000 CD. Insert the CD.
After inserting the CD Go to Computer--C Drive--Program Files--Microsoft SQL Server--80--Tools--Binn--rebuildm.exe
Double Click the rebuildm.exe then give the path of DATA folder from the CD(Computer--CD--*86--DATA)
After this task we can connect/start the SQL Server. Now restore the Master database with previous Backup...
As SQL Server is not starting it is not possible to restore the Master database.
To overcome this situation if you have the SQL Server 2000 CD. Insert the CD.
After inserting the CD Go to Computer--C Drive--Program Files--Microsoft SQL Server--80--Tools--Binn--rebuildm.exe
Double Click the rebuildm.exe then give the path of DATA folder from the CD(Computer--CD--*86--DATA)
After this task we can connect/start the SQL Server. Now restore the Master database with previous Backup...
No comments:
Post a Comment