SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 KILLED/ROLLBACK SQL Server 2008 R2
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

erkutgoksel
Starting Member

Turkey
4 Posts

Posted - 04/06/2013 :  04:45:41  Show Profile  Send erkutgoksel an ICQ Message  Reply with Quote
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

Edited by - erkutgoksel on 04/06/2013 04:46:52

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 04/06/2013 :  21:46:34  Show Profile  Visit russell's Homepage  Reply with Quote
You rebooted? Nothing to do now but wait.
Go to Top of Page

ahmeds08
Aged Yak Warrior

India
693 Posts

Posted - 04/08/2013 :  07:16:00  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
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
Go to Top of Page

erkutgoksel
Starting Member

Turkey
4 Posts

Posted - 04/08/2013 :  08:24:43  Show Profile  Send erkutgoksel an ICQ Message  Reply with Quote
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
Go to Top of Page

ahmeds08
Aged Yak Warrior

India
693 Posts

Posted - 04/08/2013 :  08:38:44  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
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

mohammad.javeed.ahmed@gmail.com
Go to Top of Page

erkutgoksel
Starting Member

Turkey
4 Posts

Posted - 04/08/2013 :  09:21:29  Show Profile  Send erkutgoksel an ICQ Message  Reply with Quote
yes, everthing is fine now. But 18 minutes felt like 18 hour

Erkut Goksel
Software Engineer
istanbul/Turkey
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 04/08/2013 :  11:28:08  Show Profile  Visit russell's Homepage  Reply with Quote
Always does!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000