Unable to start SQL Server service

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

Unable to start SQL Server service

Author

Topic

venkath
Posting Yak Master

202 Posts

Posted - 2006-09-07 : 11:12:29

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

899 Posts

Posted - 2006-09-07 : 12:27:27

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.)

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-09-07 : 12:50:25

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

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-09-07 : 14:30:36

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.)

venkath
Posting Yak Master

202 Posts

Posted - 2006-09-08 : 04:22:45

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

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-09-08 : 09:35:27

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.)

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-09-08 : 09:51:54

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"

venkath
Posting Yak Master

202 Posts

Posted - 2006-09-09 : 01:21:15

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..

venkath
Posting Yak Master

202 Posts

Posted - 2006-09-11 : 07:49:23

Hi all

Thanks for all ur help..

Finally i could rebuilt the master database,

pls guide me How to map the sa login??

Thanks

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-09-11 : 10:23:48

quote:
Originally posted by venkath

pls guide me How to map the sa login??

what do you mean?

-ec

venkath
Posting Yak Master

202 Posts

Posted - 2006-09-11 : 10:34:59

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..

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-09-11 : 11:30:57

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

venkath
Posting Yak Master

202 Posts

Posted - 2006-09-11 : 12:16:43

yes eyechart, i was using the old password.!!

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

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources