var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Urgent Help required--Error: 9003,Severity:20,State:1.
I am using Microsoft SQL Server 2000 Desktop Engine (MSDE 2000). When I restart the SQL Service, it fails to do so. I have tried running the service in command prompt & got the following error:
Error: 9003, Severity: 20, State: 1.
Cannot recover the master database. Exiting.
Kindly help as it is quite urgent & I can not afford to loose any data. Thanks.
do you have a recent backup?
I do have backup but thats not recent. I stand a chance of loosing around 15 days data by using that backup.
Hopefully you will only need a backup of the master database since it is the one being reported as corrupt.
Originally Posted by mukhijask
Read about "Restoring master databases.." in BOL for instructions.
You can also recreate the master database using the rebuildm.exe tool. Read more in BOL.