READ_ONLY KILLED/ROLLBACK. - SQL Server Forums

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

Transact-SQL (2008)

READ_ONLY KILLED/ROLLBACK.

Author

Topic

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2013-07-18 : 14:52:42

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
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-07-18 : 15:10:41

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

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2013-07-18 : 15:52:58

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources