Tuesday, March 27, 2012

BACKUP failed to complete the command sp_execute;1

Does anyone know why message appears and how to correct problem?
During a database backup the message of "BACKUP failed to complete the
command sp_execute;1" appears in the SQL log. The backup seems to complete
sucessful. The backup command is as follow:
BACKUP DATABASE @.dbname TO DISK = \\ServerA\Backup\BackupXDB.dat WITH
DIFFERENTIAL, INIT
as you may not the backup is being directed to a network drive
SQL Env: Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
May 31 2003 16:08:15
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
Thanks in advance
Did you try to apply the differential backup to see if it's valid? Also, if
you run the same command from Query Analyzer, do you get the same error?
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"SQLDBA" <SQLDBA@.discussions.microsoft.com> wrote in message
news:4649BE64-B000-4692-A59D-B7DA0E1F1C5D@.microsoft.com...
> Does anyone know why message appears and how to correct problem?
> During a database backup the message of "BACKUP failed to complete the
> command sp_execute;1" appears in the SQL log. The backup seems to
complete
> sucessful. The backup command is as follow:
> BACKUP DATABASE @.dbname TO DISK = \\ServerA\Backup\BackupXDB.dat WITH
> DIFFERENTIAL, INIT
> as you may not the backup is being directed to a network drive
> SQL Env: Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> May 31 2003 16:08:15
> Copyright (c) 1988-2003 Microsoft Corporation
> Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
> Thanks in advance
>

No comments:

Post a Comment