Error processing BACKUP DATABASE statement

From: Slava (Slava_at_discussions.microsoft.com)
Date: 01/27/05 

Date: Wed, 26 Jan 2005 20:37:07 -0800

Hello all!

I do database backup using SQL-script (BACKUP DATABASE to ...). This scripts
runs by osql utility.

How i can know - was backup successful or not.

I'm trying to use @@error variable, but it doesn't return error if device is
full or doesn't exists.
How can i do such error processing is SQL-script ?

Thanks, Slava

Relevant Pages

  • Re: ReportIoError when performing backup - what can be done?
    ... > On 2 previous occasions, and the last weekend, the transaction log on the ... > perform a full database backup after each change of recovery mode. ... did you shrink the transaction log after truncate? ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2005 Shrink issue
    ... I'm running a full database backup nightly, and my recover mode is full as ... well in SQL. ... I'm using Symantec Backup exec 11D to do the backup's. ... Logs grow until you make a database backup. ...
    (microsoft.public.sqlserver.tools)
  • Re: General Question - May Be Silly.
    ... You need to use a database backup first (i.e. using SQL ... Server tools maybe) to a hard disk on the server. ... WSS FAQ at http://wss.collutions.com ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Detaching and Attaching a Databases
    ... redo and undo phases and you will need to run another FULL backup before you can start the log backups. ... to continue restore the transaction log files made on SQL2008? ... I made a full database backup. ... I made transaction log backups every hour. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL restore table / rollback / undo table drop without backups?
    ... If you never did a database backup, then your chances are very slim, because you don't have anything to "hang" your current log backup on. ... If you ever did a database backup, then you can perform a log backup now, then restore your database backup and all subsequent log backups, but stop before this accident. ...
    (microsoft.public.sqlserver.programming)