I have an issue with a database.
Due to some other issue, the network team has restarted SQL services.
Meanwhile, the log file for this database was full, it filledup whole drive. I have attached another logfile.
When the server was broughtup, i saw the database was in recovery mode.
And after a long time, db was accessible, but the log still says,
"Recovery of database 'MAMart' (5) is 99% complete (approximately 30 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required."
I see no process even after 3 hrs.
Later i did dbcc opentran, but it told there is active transaction and the SPID is 66s !
Transaction information for database 'MAMart'.
Oldest active transaction:
SPID (server process ID): 66s
UID (user ID) : -1
Name : DELETE
LSN : (139245:82471:1)
Start time : Oct 24 2013 2:49:57:477AM
SID : 0x010500000000000515000000db8bf01f99944a3271d22e78dc200000
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Database is in Simple recovery mode. I tried many times running checkpoint with no luck.
Still not able to shrink log file.
Please share your ideas on debugging..Much Appreciated..