SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Unable to start SQL Server service
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

venkath
Posting Yak Master

India
202 Posts

Posted - 09/07/2006 :  11:12:29  Show Profile  Reply with Quote
Hi all

When i started the service, i am getting the following message
Starting up database 'master'.
Error: 9003, Severity: 20, State: 1.
Cannot recover the master database. Exiting.


i tried starting using -f -m paramters,but could not succeed
i don't have any backups for master database
is there any way i can restore it from .mdf, .ldf files..

Pls suggest..

Thanks in advance

paulrandal
Yak with Vast SQL Skills

USA
899 Posts

Posted - 09/07/2006 :  12:27:27  Show Profile  Visit paulrandal's Homepage  Reply with Quote
You're out of luck - there's nothing you can do if you don't have any backups.

Paul Randal
Lead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 09/07/2006 :  12:50:25  Show Profile  Reply with Quote
what about rebuilding the master with rebuildm? This isn't going to restore you master database, but it will build a new one for you.



-ec
Go to Top of Page

paulrandal
Yak with Vast SQL Skills

USA
899 Posts

Posted - 09/07/2006 :  14:30:36  Show Profile  Visit paulrandal's Homepage  Reply with Quote
Yes - I replied too soon. You've only lost master - none of your user data should (hopefully) be damaged. You can reinstall, re-attach your databases, recreate your logins etc...

And get a backup strategy, or you may find yourself looking for a new job if you end up losing unrecoverable data.

Paul Randal
Lead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

venkath
Posting Yak Master

India
202 Posts

Posted - 09/08/2006 :  04:22:45  Show Profile  Reply with Quote
Hi paul

Thanks for ur help..i followed the steps to rebuild the master database.but when i click on rebuild button, the server configuration
dailog box is lasting so long with progress bar moving front and back with out concluding any rebuild complete statement..

may i know why it in not ending..

Thanks
Go to Top of Page

paulrandal
Yak with Vast SQL Skills

USA
899 Posts

Posted - 09/08/2006 :  09:35:27  Show Profile  Visit paulrandal's Homepage  Reply with Quote
I'm not able to debug that over the internet. I suggest you contact product support to help you (http://support.microsoft.com/sql).

Thanks

Paul Randal
Lead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

harsh_athalye
Flowing Fount of Yak Knowledge

India
5581 Posts

Posted - 09/08/2006 :  09:51:54  Show Profile  Visit harsh_athalye's Homepage  Click to see harsh_athalye's MSN Messenger address  Send harsh_athalye a Yahoo! Message  Reply with Quote
quote:
Originally posted by venkath

Hi paul

Thanks for ur help..i followed the steps to rebuild the master database.but when i click on rebuild button, the server configuration
dailog box is lasting so long with progress bar moving front and back with out concluding any rebuild complete statement..

may i know why it in not ending..

Thanks



Was your SQL Service running when you ran the Rebuild utility?

Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page

venkath
Posting Yak Master

India
202 Posts

Posted - 09/09/2006 :  01:21:15  Show Profile  Reply with Quote
hi

no it is not ending, the steps i followed are

- copied the X86 folder from the CD to local machine

- and tried to rebuild the master database but it it not concluding..

Go to Top of Page

venkath
Posting Yak Master

India
202 Posts

Posted - 09/11/2006 :  07:49:23  Show Profile  Reply with Quote
Hi all

Thanks for all ur help..

Finally i could rebuilt the master database,

pls guide me How to map the sa login??

Thanks
Go to Top of Page

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 09/11/2006 :  10:23:48  Show Profile  Reply with Quote
quote:
Originally posted by venkath

pls guide me How to map the sa login??






what do you mean?



-ec
Go to Top of Page

venkath
Posting Yak Master

India
202 Posts

Posted - 09/11/2006 :  10:34:59  Show Profile  Reply with Quote
Hi ec,

i have rebuilt the corrupted master database from the CD,
now when i try to connect using SA login, i have been denied..
pls help me how to map the existing logins..

Go to Top of Page

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 09/11/2006 :  11:30:57  Show Profile  Reply with Quote
quote:
Originally posted by venkath
i have rebuilt the corrupted master database from the CD,
now when i try to connect using SA login, i have been denied..
pls help me how to map the existing logins..




are you using your old SA password, or are you using blank SA password? I would think that the SA password would now be blank since you rebuilt the master db.



-ec
Go to Top of Page

venkath
Posting Yak Master

India
202 Posts

Posted - 09/11/2006 :  12:16:43  Show Profile  Reply with Quote
yes eyechart, i was using the old password.!!

Now i login by blank password and changed the sa password..

Thanks
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000