database backup in killed/rollback status
hi all,
i have more 50 database on 1 server.this time full backup blocked diff backup blocking not resolve long period decide kill
one of them problem still persist blocking not fix , can not take backup because 1 backup still running in killed/rollback state.please fix issue can if go restart sql server service database can go in suspect mode or service can take long time come up
regards,
pawan singh
thanks
you should not kill spid taking backup. if there os level operation done spid, can't rolledback sql server. means, killing spid taking backup go killed/rollback status becuase has created backup file, can't "rollback" work.
why think database go suspect mode or take long time?
restart choice have!
balmukund lakhani | please mark solved if i've answered question, vote helpful other user's find solution quicker
--------------------------------------------------------------------------------
posting provided "as is" no warranties, , confers no rights.
--------------------------------------------------------------------------------
my blog | team blog | @twitter
SQL Server > Getting started with SQL Server
Comments
Post a Comment