Backup Job error

• SkyBVI

  SSCoach

  Points: 15128

  More actions

  April 27, 2011 at 7:57 am

  #147940

  Hi,

  I am backing up production db regularly at night. From last 2 months I didnt get any error message,

  2 days back, I got htis:-

  Failed:(-1073548784) Executing the query "declare @backupSetId as int

  select @backupSetId = position from msdb..backupset where database_name=N'XYZ' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'XYZ' )

  if @backupSetId is null begin raiserror(N'Verify failed. Backup information for database ''XYZ'' not found.', 16, 1) end

  RESTORE VERIFYONLY FROM DISK = N'\\\\SERVERNAME\\D$\\SQLBACKUP\\XYZ\\XYZ_backup_201104242015.bak' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND

  " failed with the following error: "Read on "\\\\SERVERNAME\\D$\\SQLBACKUP\\XYZ\\XYZ_backup_201104242015.bak" failed: 1130(Not enough server storage is available to process this command.)

  VERIFY DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

  Regards,

  Sushant

  Regards
  Sushant Kumar
  MCTS,MCP

• SkyBVI

  SSCoach

  Points: 15128

  More actions

  April 27, 2011 at 8:14 am

  #1316612

  I am storing the backup via job in SSMS to another server.

  Regards,

  Sushant

  Regards
  Sushant Kumar
  MCTS,MCP

• zygonr

  Old Hand

  Points: 329

  More actions

  April 27, 2011 at 8:30 am

  #1316634

  "(Not enough server storage is available to process this command.)

  Did you verify the above error message, if space is avaliable on backup drive.

• SkyBVI

  SSCoach

  Points: 15128

  More actions

  April 27, 2011 at 8:41 am

  #1316645

  Yes there is enough free space on it...360gb out of 1.2TB is free.

  Regrds,

  Sushant

  Regards
  Sushant Kumar
  MCTS,MCP

• sachnam

  SSCrazy

  Points: 2317

  More actions

  April 27, 2011 at 10:37 pm

  #1317026

  Are you using any backup tool or it is just a native sql backup.

  It seems to be native though. but just wanted to confirm.

  Also, do you have sufficent RAM available to perform the backup activity. I have personally experienced backups getting failed because of memory pressure. But many a times it occurs when there is a backup tool running outside the buffer pool which could be impacted by memory pressue at system level.

  So, pls confirm this..