Post reply

Variation on error 824 that some other threads cover (Sql 2005)

  • February 13, 2008 at 11:39 am

    #203476

    I could start SQL Server Management Studio 2005 (RTM) one morning and in the evening it would not start.

    I tried starting in the services but received following prompt:

    The SQL Server (MSSQLSERVER) service on local computer started then stopped......

    I looked in the event log:

    SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:361; actual 0:0). It occurred during a read of page (1:361) in database ID 1 at offset 0x000000002d2000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf'.

    I tried running SQLCMD to run DBCC CHECKDB but received:

    Names Piped Provider: Could not open a connection to sql server....

    I have tried changing the settings to enable SQLCMD but no joy.

    What can I do? Does it come down to reinstalling SQL Server? Is it possible for me to run SQLCMD?

    If it means reinstalling (or should I uninstall and then install), I have the mdf and ldf of the database I am working on, is the best thing to create the database again (blank) take it offline and then replace the mdf and ldf files with the backed up one?

    Thank you for the help, have spent at least ten hours on it now and stumped!

  • February 13, 2008 at 11:58 am

    #777997

    You've got a corrupt page in the master database. Looks like the page has been zeroed out by something in the IO subsystem (most likely your hardware).

    Master is critical for the server being able to start. Given that the server won't start, you're looking at restoring master from your backups. This is a non-trivial exercise. There are various explanations on the net for different versions - I seriously recommend you call Product Support to help you.

    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 2 posts - 1 through 2 (of 2 total)

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