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

Popular posts from this blog

Motherboard replacement

Cannot create Full Text Search catalog after upgrading to V12 - Database is not fully started up or it is not in an ONLINE state

Remote Desktop App - Error 0x207 or 0x607