Post reply

Determine if a backup is currently running

  • April 17, 2007 at 9:29 am

    #116917

    Hi All,

    Does any one know if there is a flag set some ware to determine if a full or a differential back is currently running on an database

     

    Thank You,

    Jim

  • April 17, 2007 at 9:46 am

    #700947

    I think you can query sysprocesses to see which database is being backed up.

    select dbid, cmd

    from master.dbo.sysprocesses

    where cmd like '%backup%'

    Greg

    Greg

  • April 18, 2007 at 9:03 pm

    #701317

    Check

    msdb..backupset

Viewing 3 posts - 1 through 2 (of 2 total)

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