Re: BACKUP failed to complete the command sp_execute;1

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Peter Yeoh (nospam_at_nospam.com)
Date: 09/10/04 

Date: Fri, 10 Sep 2004 09:11:20 +0800

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
>

Relevant Pages

  • Re: Windows could not start because the following file is missing or corrupt: System32DriversNtfs.sy
    ... Backup a bad filesystem and the Backup maybe worthless, ... Using the F10 option, once you get to the C: prompt, put the floppy in ... and see if ntfs.sys file is on the floppy ... Alt and D keys at the same time to go to a command prompt. ...
    (microsoft.public.windowsxp.general)
  • [SUMMARY] Using tar to restore files backup up using Veritas Netbackup
    ... Once you import the catalog data, you can select the files with Netbackup client softwre. ... Step 1 is performed with the first form of the command shown above and recreates catalog entries for the backups that are on the specified media. ... For example, if a backup is imported on 11/14/98 and its retention level is one week, its new expiration date is 11/21/98. ...
    (SunManagers)
  • Re: Automated Backup Help
    ... OK...I placed that entry before the ntbackup command as instructed but got exactly the same results I have previously described except for the command being echoed to the command prompt. ... It is very frustrating....obviously something is wrong and causing the backup to fail or terminate early but there is no indication of an error message at all. ... REM These are the "ntbackup" parameters and switches used; ...
    (microsoft.public.windows.server.scripting)
  • RE: Recommedndation on filecopy utility that truncates long filena
    ... I'm not a tech guy -- so could you help me understand that command, ... Area to provide me a backup solution, and told him I save a lot of webpages ... "Rename them, with shorter names". ... friend says "just buy hard drives, they're so cheap now, I wouldn't bother ...
    (microsoft.public.windowsxp.newusers)
  • Re: Backing Up Media Center Recordings
    ... The HELP command is good at the CMD ... It will always backup the files that have the ARCHIVE attribute set. ... cd "\Documents and Settings" ... recordings manually using Windows Explorer. ...
    (microsoft.public.windows.mediacenter)