Kill DB backup process?

techresearch7777777 1,921 Reputation points
2021-03-20T08:43:51.123+00:00

Hello, will sending a KILL/terminate command potentially corrupt/negative impacts during a long running large DB BACKUP ?

Thanks in advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,446 questions
0 comments No comments
{count} votes

Accepted answer
  1. CarrinWu-MSFT 6,891 Reputation points
    2021-03-22T05:16:17.327+00:00

    Hi @techresearch7777777 ,

    Are you trying to kill the process of backup? If yes, you can kill it, the operation will not impact Databases, but you have to be cautious as if you kill backup process, it has to ROLLBACK which will take some or more time.

    Best regards,
    Carrin


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Erland Sommarskog 116.5K Reputation points MVP
    2021-03-20T10:34:42.013+00:00

    The backup file produced will of course not be usable. If this is a file with multiple backups that you are appending to, I don't really know what happens. Not the least with the backups that might be after the killed backups.

    But the database will of course not be affected.

    0 comments No comments

  2. techresearch7777777 1,921 Reputation points
    2021-03-22T23:01:18.397+00:00

    Thanks for the replies.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.