Cannot recover the database master. SQL Server 2005

if you have message like this when you starting sql server service on your computer, its mean, your database ‘master’ on your sql server. is corrupted. You can check this message in event viewer  its mean you need to recover your database master.

cannot recover the database master

To fix this issue, you need to rebuild the database master with CD Installation:

  1. insert the CD installation to your drive
  2. open Run and type : “start /wait [your path driver]/setup.exe /qn INSTANCENAME=[YOUR INSTANCE NAME, BYDEFAULT =MSSQLSERVER] REINSTALL=SQL_Engine REBUILDATABASE=1 SAPWD=[YOUR SA PASSWORD]
  3. then press enter.

this comman will rebuild your database master. after this process, try to running the sql server service, and your service will be running well. but your database will gone after you done this process. Do not panic, because the actual database (.mdf file) still on your computer. You just need to attached the database to your engine.

 

source: http://eitwebguru.com/mssql-2005-error-cannot-recover-the-master-database/
Advertisements

About Polairut

Abadi Harahap, I'm working in Supply Chain Third Party Logistic as Supply Chain Consultant. Daily in touch in Warehouse Operation, Transport System and provide advice for solution. I like hiking, open a tent in a mountain, enjoy the nature. Sometime write code for web, Android app and its for pleasure, not for pressure. Any opportunity you can drop me an email at badi_hrp@yahoo.com . I will give you my mobile. thanks.

Posted on January 4, 2012, in happy coding and tagged , , , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: