Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can't access database deferred transactions Expand / Collapse
Author
Message
Posted Thursday, June 20, 2013 3:57 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, June 25, 2014 7:02 AM
Points: 75, Visits: 289
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



Post #1465974
Posted Thursday, June 20, 2013 10:06 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:04 AM
Points: 1,202, Visits: 1,671
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?
Post #1466027
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse