Comments
12 comments
-
It looks like your remote share (\\sys1\p$\backups\) was unreachable from your SQL Server box during that time. -
i can access the remoteshare using run command from sqlbox,every time i run this job i get the same error
-
Could you please check if the SQL Backup Agent service startup account has rights to that remote share?
Thanks. -
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.
-
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. -
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'master..sqbackup'. -
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]"'
-
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 -
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. -
how can we know weather my system is running near its limit i.e; physical memory running low, and page file usage extremely high?
-
The Windows Task Manager ought to show you the numbers.
Thanks. -
thanks for your help,working fine now
Add comment
Please sign in to leave a comment.
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.)