Post reply

How to abort a running backup job?

  • October 1, 2004 at 4:58 pm

    #89449

    On more than one occassions I needed to stop/abort a running backup job. When I stop the backup job in SQL Server Agent Jobs (EM), the job stops but the backup continues to run until it is completed.

    Is there a way to abort a backup job and take the DB out of backup mode?

    Thanks for any input.

  • October 1, 2004 at 7:00 pm

    #525096

    Kill the connection using

    kill {spid}

    ?

    Seems to work, but I don't know if there's any side-effects.

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • October 4, 2004 at 2:41 am

    #525154

    Thanks, Peter. I wonder if that would leave the DB in backup mode like it would in Oracle. Can anyone confirm this? Thanks.

  • October 4, 2004 at 9:27 am

    #525251

    I don't know about Oracle, but there isn't really a 'backup' mode in SQL Server.

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • October 4, 2004 at 11:19 am

    #525258

    Thanks, Peter. I'll give it a try next time.

  • October 4, 2004 at 1:36 pm

    #525284

    There are places where KILL will not interrupt the process. So if it takes a few minutes, be aware that it might be finishing something before it stops the backup.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply