April 10, 2009 at 8:59 am
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.
April 10, 2009 at 9:11 am
Please post the details of those errors. Just listing the numbers is not sufficient.
Actually, if you can find the SQL error log and post the entire of it (removing server names if necessary) it would be very useful. The SQL error log is just a text file and can be accessed without the SQL engine running. It's name will be simply "ERRORLOG" I can't tell you offhand where it will be, because that depends on the installation path for SQL.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2009 at 9:22 am
Ok, i'm not working now, but monday i tell you some data of ERRORLOG.
PD: i haven't backup of master db.-
April 10, 2009 at 10:41 am
No need - if your master is corrupt and you don't have a backup, you're going to have to create a new master database, and then reattach the user databases. You're also going to have to recreate all your logins. My advice is to call Product Support and have them help you through this - it's too involved a process to try to support over an asynchronous medium like this.
Thanks
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply