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
 Transact-SQL (2008)
 READ_ONLY KILLED/ROLLBACK.
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

yosiasz
Flowing Fount of Yak Knowledge

USA
1629 Posts

Posted - 07/18/2013 :  14:52:42  Show Profile  Click to see yosiasz's MSN Messenger address  Reply with Quote
one of our development servers has gone into KILLED/ROLLBACK.
would putting the database in read_only mode kill this rollback that is just chugging away ?


USE master;
GO
ALTER DATABASE booboo
SET RESTRICTED_USER
WITH ROLLBACK IMMEDIATE;
GO
ALTER DATABASE booboo
SET READ_ONLY;
GO

ALTER DATABASE booboo
SET READ_WRITE ;
GO

ALTER DATABASE booboo
set  multi_user with rollback immediate
GO


<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion

James K
Flowing Fount of Yak Knowledge

3323 Posts

Posted - 07/18/2013 :  15:10:41  Show Profile  Reply with Quote
I don't know the answer to your question - but see if this connect article (and the link in that issue) give you any insights: http://connect.microsoft.com/SQLServer/feedback/details/433703/killed-rollback
Go to Top of Page

yosiasz
Flowing Fount of Yak Knowledge

USA
1629 Posts

Posted - 07/18/2013 :  15:52:58  Show Profile  Click to see yosiasz's MSN Messenger address  Reply with Quote
seems like my idea will not work as it now creates a resource contention with the rollback when trying to to do SET READ_ONLY;

<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion
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