KILLED/ROLLBACK SQL Server 2008 R2

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

KILLED/ROLLBACK SQL Server 2008 R2

Author

Topic

erkutgoksel
Starting Member

4 Posts

Posted - 2013-04-06 : 04:45:41

Cannot Kill Process in KILLED/ROLLBACK condition. All operations are stoped and db inRecorveryMode now. SQL db is 43GB & MS SQL Server 2008 R2 SP1. How much time does it take? I must return from backup or waiting inRecoveryMode? Any ideas?

Erkut Goksel
Software Engineer
istanbul/Turkey

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-04-06 : 21:46:34

You rebooted? Nothing to do now but wait.

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2013-04-08 : 07:16:00

you can check the sql server error log,that will show you how much percentage of recovery ha been done.
looks like a server reboot.

mohammad.javeed.ahmed@gmail.com

erkutgoksel
Starting Member

4 Posts

Posted - 2013-04-08 : 08:24:43

InRecovery process took 18 minutes.
I did not stop SQL server service.
I did failover operation from failover cluster manager.
My aim is reindex and purge deleted nodes some tables.
But suddenly I found my sql server in killed/rollback situation.

Erkut Goksel
Software Engineer
istanbul/Turkey

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2013-04-08 : 08:38:44

quote:
Originally posted by erkutgoksel

InRecovery process took 18 minutes.
I did not stop SQL server service.
I did failover operation from failover cluster manager.
My aim is reindex and purge deleted nodes some tables.
But suddenly I found my sql server in killed/rollback situation.

Erkut Goksel
Software Engineer
istanbul/Turkey

Good that the database has recovered