Post reply

information about end backup

  • December 8, 2006 at 5:23 am

    #153328

    Hi

    i'm new in sql 2000, i would like to know where i can see, in the system tables , that a backup is ending.

    Because in the sqllog file , i have an error message regarding a time out , and when i check the dump file,  is valid .

    Thanks.

     

     

     

  • December 8, 2006 at 8:02 am

    #676911

    msdb..backupset

  • December 8, 2006 at 2:08 pm

    #677049

    You don't see time out information in system tables...

    You may see some information in msdb..sysjobhistory table.

    select * from msdb..backupset

    where database_name = <>

    order by backup_start_date desc

    select step_id, step_name, message from msdb..sysjobhistory

    where job_id in (select job_id from msb..sysjobs where job = '<jobname>')

    order by run_date desc

    MohammedU
    Microsoft SQL Server MVP

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

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