Friday 10 February 2012

SQL SERVER - Not Starting (SQL Server 2000 Not Starting)


One day when I started the server I got a message. Microsoft SQL server not starting. While Restarting the SQL server it is not possible. Mostly SQL Server is not starting because master database is corrupted. Since SQL server is not started we cant restore the master database.

If you have SQL Server 2000 CD then you can restore the master database. Insert the  SQL SERVER 2000 CD. Then go to 
MY Computer-----
C DRIVE------Program Files-------Microsoft SQL Server-----------80-----------Tools----------Binn---------rebuildm.exe

Double click  on rebuildm.exe   then you have to show the path of DATA folder from the CD

(ie   Browse the CD  open the folder---*86--------DATA)

After this you can connect/ start SQL server.   The restore the master database with the  backup(Previous Days).  Then you can re start Sql server 2000.  and start working all the Applications   http://saparavur.blogspot.com

5 comments:

Unknown on 11 February 2012 at 11:49 said...

thank u for the valuable tip

Anonymous said...

While restoring master database, it asks for single user mode. how to make single user mode? kindly guide

saparavur on 13 February 2012 at 10:24 said...

Just Right Click on the database, select Prorperties. In the properties menu click on options . Change the Restrict access mode to Single user

dheeru24k on 17 February 2012 at 11:28 said...

U r right saparavur sir.

System Administrators, Indiapost,Kerala on 6 July 2012 at 11:10 said...

hai it is very useful.

Post a Comment

Related Posts Plugin for WordPress, Blogger...

Sample text


Advertisement

 

Copyright 2008 All Rights Reserved saparavur theme by SA PARAVURr Converted into Blogger Template by SA PARAVUR