September 28, 2018 at 7:00 pm
I am getting a strange problem at SQL instance (Version Microsoft SQL Server 2008 R2 (SP3-GDR) (KB4057113)). Server restart unexpectedly with following error:
Error: 3316, Severity: 21, State: 2. During undo of a logged operation in database 'tempdb', an error occurred at log record ID (14236:17637:199). The row was not found. Restore the database from a full backup, or repair the database.
Error: 3314, Severity: 21, State: 4. During undoing of a logged operation in database 'tempdb', an error occurred at log record ID (14236:17637:199). 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.
Error: 3449, Severity: 21, State: 1.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.
After restart it runs for some time (few minutes or hours) and again restart with same error. There are no errors when DBCC CHECKDB is run on system databases.
Changing location of tempdb files and and recreating it in new location also doesn't work.
Am I missing something? Please suggest.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply