SQL Services will not start... (SQL Server 2000 SP4)

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

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




    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]

    How to ask for help .. Read Best Practices here[/url].

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply