how to stop long roll back on SQL server 2005 ,
Database
2
Posts
2
Posters
0
Views
1
Watching
-
DBCC CHECKDB 'TEST" I just cancelled this queury to run my DB full backup . this qeuery rolling back more than 7hrs . how do i stop thi roll back and get my full backup . this qeury was running from SQL server agent .
As far as I know you can't, stopping the database may leave it in an unrecoverable state. We have had dev databases in this state and had to recover from backups.