Wednesday, August 11, 2010

Recovering from corrupt master (system) in MS SQL 2000!!!

SQL server 2000 wont start? This is not for SQL 2005. Check the logs and there is a corrupt master database right?
Well, get ready for the fun because it all starts here.
  • You will need a utility called rebuildm.exe ( its usually in your ms SQL 2000 disk)
  • This will install a new master, model, tempdb, msdb
  • start the SQL service in single user mode
  • Launch Enterprise Admin in single user mode to recover master database.
  • All the databases, tables, views, users and objects should be back in place

No comments:

Post a Comment