October 2, 2011 at 8:28 pm
Hi,
I'm using SQL server 2008. I have a backup that i tried to kill because. After killing this backup it's been two days i have the same message when i run KILL 119 WITH STATUSONLY
SPID 119: transaction rollback in progress. Estimated rollback completion: 4%. Estimated time remaining: 5066858 seconds.
Except that the estimated time remaining kept growing. I need to set up a new backup for and i can't I get the folowing error message :
backup, file manipulation operation (such as alter DATAbase Add file) and
encryption changes on a database must serialized. Reissue the statement
after the current backup or file manipulation operation is completed
When i run the folowing statement : sp_lock 119 I get
Spid dbid ObjId IndId Type Ressource Mode Status
119500DB[BULKOP_BACKUP_LOG] NULLGRANT
119500DB SGRANT
119500DB[BULKOP_BACKUP_DB] UGRANT
I'd like to know i you have any idea of how to get my database in a normal state again. I'm afraid that if i restart the sql service, the transation will be rolledback and then provoke an unavailibility on the production server. Or that the transaction would never go back to a normal state.
October 2, 2011 at 8:48 pm
Check out this post with possible solution to your problem.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply