SQL Backup job failed

• 
  It looks like im running out of diskspace:

  BACKUP failed to complete the command BACKUP DATABASE [STORAGE] TO VIRTUAL_DEVICE = 'SQLBACKUP_15D9C182-79F3-479E-B815-FA3C8F7BCABE' WITH BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (STORAGE), 10-07-2006 10:53:12', DESCRIPTION = N'Backup on 10-07-2006 10:53:12 Server: IW

  
  What drive does VIRTUAL_DEVICE use and is it possible to change it?

  cml July 10, 2006 05:05

  - 0 +
• 
  VIRTUAL_DEVICE is a logical device name. The backup file is physically written to the drive you specified for the DISK options.
  
  Could you pls check the log file for the backup process? It's found in the 'All users' application data folder e.g.
  
  C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\(local)
  
  What SQL Server error messages are logged in that file?

  petey July 10, 2006 12:31

  - 0 +
• 

  SQL Backup log file
  10-07-2006 10:53:12: Backing up STORAGE (full database) to: 
    \\aodb\f$\MSSQL Full backups\BACKUPIW\FULL_(local)_STORAGE_20060710_105131.sqb
  
  10-07-2006 10:53:12: BACKUP DATABASE [STORAGE]  TO DISK = '\\aodb\f$\MSSQL Full backups\BACKUPIW\FULL_(local)_STORAGE_20060710_105131.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
  
  10-07-2006 10:56:49: Thread 0 error: 
  Error 620: Error writing to backup file(s).
  Process terminated unexpectedly. Error code: -2139684860
  Thread 0 warning: 
  Warning 210: Error writing to backup file:  \\aodb\f$\MSSQL Full backups\BACKUPIW\FULL_(local)_STORAGE_20060710_105131.sqb
  Warning: System error code:  (The specified network name is no longer available)
  
  10-07-2006 10:58:59: Server: Msg 3013
  BACKUP DATABASE is terminating abnormally.
  10-07-2006 10:58:59: Server: Msg 3202
  Write on 'SQLBACKUP_15D9C182-79F3-479E-B815-FA3C8F7BCABE' failed, status = 112. See the SQL Server error log for more details.
  10-07-2006 10:58:59: Failed to close vdi.
  

  
  (The specified network name is no longer available)?? i dont believe that the server went down or something.
  Maybe its because the database is very big? its 40gb, it cant transfer it? i dont know.

  cml July 11, 2006 02:29

  - 0 +
• 
  Do the backup files get partially generated? Are they always the same size when the backup fails?
  
  SQL Backup has no limitations on file size when writing to a network drive.
  
  I would suggest running a network monitoring tool on both machines, just to confirm that network connectivity is not a problem. You could use the Network Interface performance object in Windows Performance Monitor. Select the Current Bandwidth counter, and the correct network interface instance.

  petey July 11, 2006 22:59

  - 0 +

Add comment

Please sign in to leave a comment.