What are the challenges you face when working across database platforms? Take the survey
Options

backup job failed

DBA007DBA007 Posts: 16
edited September 16, 2010 9:27AM in SQL Backup Previous Versions
my backup job failed with the below error

9/2/2010 4:00:00 AM: Backing up one (full database) to:
9/2/2010 4:00:00 AM: \\sys1\p$\backups\FULL_(local)_one_20100902_040000_01.sqb
9/2/2010 4:00:00 AM: \\sys1\p$\backups\FULL_(local)_one_20100902_040000_02.sqb
9/2/2010 4:00:00 AM: \\sys1\p$\backups\FULL_(local)_one_20100902_040000_03.sqb

9/2/2010 4:00:01 AM: BACKUP DATABASE [one] TO VIRTUAL_DEVICE = 'SQLBACKUP_60855381-A711-400B-9EA8-175A78781996', VIRTUAL_DEVICE = 'SQLBACKUP_60855381-A711-400B-9EA8-175A7878199601', VIRTUAL_DEVICE = 'SQLBACKUP_60855381-A711-400B-9EA8-175A7878199602' WITH BUFFERCOUNT = 18, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (one), 9/2/2010 4:00:00 AM', DESCRIPTION = N'Backup on 9/2/2010 4:00:00 AM Server: server1 Database: one', FORMAT

9/2/2010 4:05:32 AM: Thread 0 error:
Error 605: Error creating backup file(s). No files could be created.
9/2/2010 4:05:32 AM: Warning 200: Thread 0 warning:
9/2/2010 4:00:01 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:00:31 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:01:01 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:01:31 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:02:01 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:02:31 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:03:01 AM: Warning 480: Failed to create output folder:
\\sys1\p$\backups9/2/2010 4:03:31 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:04:01 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:04:31 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:05:01 AM: Warning 480: Failed to create output folder: \\sys1\p$\backupsWarning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:05:32 AM:
9/2/2010 4:05:32 AM: Thread 1 error:
Error 605: Error creating backup file(s). No files could be created.
9/2/2010 4:05:32 AM: Warning 200: Thread 1 warning:
9/2/2010 4:00:01 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:00:31 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:01:01 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:01:31 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:02:01 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:02:31 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:03:01 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:03:31 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:04:01 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:04:31 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:05:01 AM: Warning 480: Failed to create output folder: \\sys1\p$\backupsWarning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:05:32 AM:
9/2/2010 4:05:32 AM: Thread 2 error:
Error 605: Error creating backup file(s). No files could be created.
9/2/2010 4:05:32 AM: Warning 200: Thread 2 warning:
9/2/2010 4:00:01 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:00:31 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:01:01 AM: Warning 480: Failed to create output folder:
\\sys1\p$\backups9/2/2010 4:01:31 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:02:01 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:02:31 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:03:01 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:03:31 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:04:01 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:04:31 AM: Warning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:05:01 AM: Warning 480: Failed to create output folder: \\sys1\p$\backupsWarning 480: Failed to create output folder: \\sys1\p$\backups9/2/2010 4:05:32 AM:
9/2/2010 4:05:32 AM: SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
9/2/2010 4:05:32 AM: SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_60855381-A711-400B-9EA8-175A78781996:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
9/2/2010 4:05:32 AM: SQL error 3202: SQL error 3202: Write on "SQLBACKUP_60855381-A711-400B-9EA8-175A78781996" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)

Comments

  • Options
    peteypetey Posts: 2,358 New member
    It looks like your remote share (\\sys1\p$\backups\) was unreachable from your SQL Server box during that time.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    i can access the remoteshare using run command from sqlbox,every time i run this job i get the same error
  • Options
    peteypetey Posts: 2,358 New member
    Could you please check if the SQL Backup Agent service startup account has rights to that remote share?

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    the backupagent service startup account hsa rights to the remote share,but the job was failing with SQL Backup job failed with exitcode: 790 SQL error code: 3202 [SQLSTATE 42000] (Error 50000). The step failed.
  • Options
    peteypetey Posts: 2,358 New member
    Could you please run the following using SQL Server Management Studio:
    EXEC master..sqbackup '-sql "BACKUP DATABASE model TO DISK = [\\sys1\p$\backups\model.sqb]"'
    
    and post the output here?

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    Msg 2812, Level 16, State 62, Line 1
    Could not find stored procedure 'master..sqbackup'.
  • Options
    peteypetey Posts: 2,358 New member
    Sorry, that should have been sqlbackup instead of sqbackup i.e.
    EXEC master..sqlbackup '-sql "BACKUP DATABASE model TO DISK = [\\sys1\p$\backups\model.sqb]"'
    
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    this is the result i got,but the shared drive contains 500gb of free space

    Backing up model (full database) to:
    \\sys1\p$\backups\model.sqb

    Error: Thread creation error: Not enough storage is available to process this command
    Error: Thread creation error: Not enough storage is available to process this command
    Warning 402: Failed to open local data store: Unspecified error

    SQL Backup exit code: 500
    exitcode 500
    sqlerrorcode 0
    filename001 \\sys1\p$\backups\model.sqb
  • Options
    peteypetey Posts: 2,358 New member
    Is your system currently near its limit i.e. is physical memory running low, and page file usage extremely high?

    If not, try restarting the SQL Backup Agent service and back up the model database again.

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    how can we know weather my system is running near its limit i.e; physical memory running low, and page file usage extremely high?
  • Options
    peteypetey Posts: 2,358 New member
    The Windows Task Manager ought to show you the numbers.

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    thanks for your help,working fine now
Sign In or Register to comment.