Sql 2005 Failing to start

[mattmontalto]

Hello all... am in a bit of a jam and could use some good advice.... I had the array that holds all my databases crash... the array has bee restored and has all the data on it, but sql will not start... seems to be analysis services and sql server agent, and the sql server service that will not start... nothing on the server has changed... only that the array with the mdfs had dissappeared for a while and has now come back... version is sql 2005.... any feedback would be greatly appreciated... thank you

 

[SQLBill]

Where is the master database's mdf and ldf?

Is the server actually seeing the array? I've had it happen where the server still couldn't see the array.

Have you checked the services on the server? Are the SQL Server services running?

Have you checked the Windows Event logs to see if there are any error messages related to this issue?

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[mattmontalto]

thanks for getting back to me... The server is now seeing the array, it is just that sql will not start... specifically Analasys Services, SQL Server & SQL Server Agent....

Event log is loggin 17058 and 19019... which essentially is saying that sql failed to start and that sql failed to read the error log.... I have pasted the contents of that error log being referenced below.... Seems to say it cannoot open the log because access is denied....

Since this SQL Server is using MS Clustering, I tried to fail over to the other server and that one does the same thing...which leads me to think it is more a problem with the data on the array than the actual sql software... Any wisdom you can share would be greatly appreciated...thanks again....

Matt


2013-03-15 16:45:48.68 Server Microsoft SQL Server 2005 - 9.00.5000.00 (X64)
Dec 10 2010 10:38:40
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

2013-03-15 16:45:48.68 Server (c) 2005 Microsoft Corporation.
2013-03-15 16:45:48.68 Server All rights reserved.
2013-03-15 16:45:48.68 Server Server process ID is 7432.
2013-03-15 16:45:48.68 Server Authentication mode is MIXED.
2013-03-15 16:45:48.68 Server Logging SQL Server messages in file 'F:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2013-03-15 16:45:48.68 Server This instance of SQL Server last reported using a process ID of 1692 at 3/15/2013 4:45:34 PM (local) 3/15/2013 8:45:34 PM (UTC). This is an informational message only; no user action is required.
2013-03-15 16:45:48.68 Server Registry startup parameters:
2013-03-15 16:45:48.68 Server -l F:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2013-03-15 16:45:48.68 Server -e F:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2013-03-15 16:45:48.68 Server -d F:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2013-03-15 16:45:48.68 Server SQL Server is starting at high priority base (=13). This is an informational message only. No user action is required.
2013-03-15 16:45:48.68 Server Detected 16 CPUs. This is an informational message; no user action is required.
2013-03-15 16:45:48.84 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2013-03-15 16:45:48.84 Server Lock partitioning is enabled. This is an informational message only. No user action is required.
2013-03-15 16:45:48.87 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2013-03-15 16:45:50.07 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2013-03-15 16:45:50.08 Server Database mirroring has been enabled on this instance of SQL Server.
2013-03-15 16:45:50.09 spid5s Starting up database 'master'.
2013-03-15 16:45:50.09 spid5s Error: 5172, Severity: 16, State: 15.
2013-03-15 16:45:50.09 spid5s The header for file 'F:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf' is not a valid database file header. The PageAudit property is incorrect.

 

[mattmontalto]

from what I understand from the error log I posted and my experience trying to get this to run,.... It seems that the master database is corrupt... I have been trying desperately to get the command to rebuild it right, but to no avail.... can anyone lead me in the right direction here to get the master database rebuilt.???? Thanks

 

[SQLBill]

check out this link:

http://social.msdn.microsoft.com/Fo.../thread/657123c4-5eac-4728-b633-e80757dd6847/

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[SQLScholar]

Long shot. I would try opening the SQL config manager. Change the login the SQL Service to something else - then change it back to whatever account you want to use.

When you chose an account here - it should make sure you have the correct permissions.

Do this at your own risk however!

Dan

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[mattmontalto]

Thanks all for your help.... basically all the DB's that were on that array seem to be corrupted. I tried attaching some of the to another sql server I set up and they will not attach... but not only that, but any of the .bak files that were on that array will not restore to the new server.... fortunately I had those .bak files on a tape from the night before and they were able to be restored to the new sql server.... was just an unbelievable disaster.... I had tried all those command line things to try and get sql to rebuild its system db's, but to no avail... coincidentally I am in the process of moving my dbs to a new server anyway, so this just really sped up the process... thanks again everyone for all your help

Matt