May 7, 2013 at 4:39 am
Hi,
I have installed 3 new instances of SQL Server 2012 on a stand alone server. SQL Service is set to automatic on all of them. Yet, suddenly, all the instances have shut down abruptly throwing the following errors.
Need some advice around this issue?
SQL Server must shut down in order to recover a database (database ID 2). The database is either a user database that could not be shut down or a system database. Restart SQL Server. If the database fails to recover after another startup, repair or restore the database.
During undoing of a logged operation in database 'tempdb', an error occurred at log record ID (438:376:163). Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup, or repair the database.
May 7, 2013 at 4:45 am
The build that I am running is this - 11.00.3128
May 16, 2013 at 8:48 am
Just checking if this question went unnoticed.
May 16, 2013 at 11:29 am
This indicates that you have a problem with tempdb (database ID 2). This could be related to the SAN dropping the connection, or corruption on the LUN, or some other problem.
You need to review all relevant event logs and error logs to determine what is causing the server to drop access to that database file.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply