krishnaprasad14 (4/30/2012)

---

Thank you very much for all .....

Issue is resolved and Now This DB is up and running .........

http://www.sqlskills.com/BLOGS/PAUL/post/Do-transactions-rollback-when-DBCC-CHECKDB-runs.aspx%5B/quote%5D

That's talking about the snapshot creation upon running a normal checkDB. If you run checkDB with any of the repair operations and cancel that, it really does have to roll back any of the repairs it did.