CAN THE DBCC CHECKDB REPAIR BE ROLLEDBACK IN A TRAN

• abishekshroff

  SSCrazy

  Points: 2040

  More actions

  May 14, 2009 at 4:38 pm

  #221368

  IS DBCC CHECKDB WITH REPAIR ALLOW DATA LOSS be put in a transaction. I tried to put it in transaction and it wasn't able to do it.

  I have heard that it can be put it transaction and can be rolled back

  SQL SERVER 2005 Version SP3

• Paul Randal

  One Orange Chip

  Points: 29544

  More actions

  May 14, 2009 at 5:33 pm

  #994978

  Yes, absolutely it can. Can you post what you tried to do and the error you received?

  The only exception is if the database is in emergency mode.

  Paul Randal
  CEO, SQLskills.com: Check out SQLskills online training!
  Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
  SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
  Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005