April 9, 2009 at 4:16 pm
I have a SQL 2000 with RAID 1, last day an error happened with the second mirror, after restart it, this occurs in Event Log:
- 18052
error 823, severity 24, state 2
error 3313, severity 21, state 2
- 17052
Cannot recover the master database exiting...
And when i wish to connect to my server this message appears:
A connection could not be established to myserver
Reason: SQL Server does not exist or access denied
Thanks for your help.
PD: I read this by Perry Whittle in
SQL Server 2005 » Administering » Master database corruption:
"not sure about that but what i just did was corrupt my master completely so sql wouldnt start. I had another instance running on the same box so i stopped the service for that instance and copied the master.mdf and masterlog.ldf over to the corrupt instance and the service with the corrupt master db then starts. I'll test out the other scenario now and get back shortly."
I have other instance in WinXP. I'm not working now, but monday i'll try this.
April 11, 2009 at 3:19 pm
Do you have backup for you master database?
I would rebuild the database and restore it from backup to get in operations. Copying master database from another instance is not best option.
Thanks.
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply