Post reply

Can't access database deferred transactions

  • June 20, 2013 at 3:57 pm

    #276488

    Hi, we have a big problem.

    Today we change a table structure on db.

    Meanwhile sql was working the disk where our db is fail.

    After fix that we restart the server and our database start recover.

    this are the logs.

    2013-06-20 18:08:26.94 spid16s Recovery of database 'sistema' (7) is 96% complete (approximately 67 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.

    2013-06-20 18:08:31.70 spid16s Recovery of database 'sistema' (7) is 97% complete (approximately 62 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.

    2013-06-20 18:08:51.70 spid16s Recovery of database 'sistema' (7) is 97% complete (approximately 42 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.

    2013-06-20 18:08:53.61 spid16s Recovery of database 'sistema' (7) is 98% complete (approximately 40 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.

    2013-06-20 18:09:11.89 spid16s Recovery of database 'sistema' (7) is 99% complete (approximately 20 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.

    after db recover we cant access to the table or config (if we try to access the config management studio says the are blockings)

    if I run a query to sys.databases I see that the database is ONLINE.

    if I try to run DBCC checkdb, said the is deferred transactions.

    SQL server Version

    Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Sep 21 2011 22:45:45 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

    I dont know what i have to do now, I dont know if when server start try to rollback the deferred trans.

    Thanks for any help.

    greetings from argentina

  • June 20, 2013 at 10:06 pm

    #1626188

    Deferred transactions:

    http://msdn.microsoft.com/en-AU/library/ms188290.aspx

    How did you fix the underlying disk issue? Was the database restored from backup?

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

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