Backup failed

Last post 05-20-2008 9:05 AM by sroscoe. 3 replies.
Page 1 of 1 (4 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next
  • 05-19-2008 7:15 AM

    • sroscoe
    • Not Ranked
    • Joined on 05-19-2008
    • Washington, DC
    • Posts 2

    Backup failed

    Hi,

    We are running SQL Server 2000 SP3, I am receiving an error message in the sql log:  BACKUP failed to complete the command backup database  to VIRTUAL_DEVICE='VNBU0-3040-3984' with blocksize = 65536, maxtransfersize = 65536, buffercount = 1.  Now, the odd thing about this is that the database it is pointing to does not exist.  It did exist previously and was deleted.  The backups are performed with a maintenance plan, selecting all databases.  I have deleted and recreated the maintenance plan and am still getting the error message.  We also use NETBACKUP, but it only backs up the .bak files.  Any ideas would be appreciated.  THANKS!

    Filed under:
  • 05-20-2008 3:08 AM In reply to

    Re: Backup failed

     Hi,

    All maintenance plans db will be stored in the table 'sysdbmaintplan_databases' in msdb database. please check there once.

    Thanks.

    John 

  • 05-20-2008 3:51 AM In reply to

    Re: Backup failed

    true said, you need to check sysdbmainplan_history table in MSDB database, againts the database name which was exists earlier and remove the records if they exists.

    Hemantgiri S. Goswami | MS SQL Server MVP
    -------------------------
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami

    http://hemantgirisgoswami.blogspot.com
    http://forums.surat-user-group.org/

    View Hemantgiri S. Goswami's profile on LinkedIn

    Disclaimer: This post is provided as is, for the sake of knowledge sharing only.
  • 05-20-2008 9:05 AM In reply to

    • sroscoe
    • Not Ranked
    • Joined on 05-19-2008
    • Washington, DC
    • Posts 2

    Re: Backup failed

    I have checked both the sysdbmaintplan_history and sysdbmaintplan_databases tables and the database that is giving the error is not in either table.  I am still periodically getting this same error.

Page 1 of 1 (4 items)
Active Topics   My Discussions    Unanswered Posts


© 2000 - 2007 vDerivatives Limited All Rights Reserved.