How can we help you today? How can we help you today?
joes
Activity overview Badges (0) Posts (3) Comments (5)

Comments

Sort by recent activity
Below is the error log, i see it says there isn't enough space.. which there is plenty of free space.. so I'm not sure why it states that.. it hasn't seemed to work correctly since being moved to sql 2005. thanks for your help. joe SQL Backup log file 5/6/2007 10:10:00 AM: Backing up Tradindit (differential database) to: \\cgsqlba001\prodback\CQLARCHI003\diff\DIFF_(local)_Tradindit_20070506_101000_01.sqb \\cgsqlba001\prodback\CQLARCHI003\diff\DIFF_(local)_Tradindit_20070506_101000_02.sqb 5/6/2007 10:10:00 AM: BACKUP DATABASE [Tradindit] TO DISK = '\\cgsqlba001\prodback\CGSQLARCHI003\diff\DIFF_(local)_Tradindit_20070506_101000_01.sqb', DISK = '\\cgsqlba001\prodback\CGSQLARCHI003\diff\DIFF_(local)_Tradindit_20070506_101000_02.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', DIFFERENTIAL, ERASEFILES_ATSTART = 2, COMPRESSION = 2, THREADS = 2 5/6/2007 10:10:42 AM: Deleting old backup file: \\cgsqlbak001\prodback\CGSQLARCHI003\diff\DIFF_(local)_Tradindit_20070503_101001.sqb 5/6/2007 10:12:02 AM: Deleting old backup file: \\cgsqlba001\prodback\CGSQLARCHI003\diff\DIFF_(local)_Tradindit_20070503_101001_02.sqb 5/6/2007 10:12:20 AM: VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684861: The api was waiting and the timeout interval had elapsed.) 5/6/2007 11:38:15 AM: SQL error 3013: BACKUP DATABASE is terminating abnormally. 5/6/2007 11:38:15 AM: SQL error 3201: Cannot open backup device 'SQLBACKUP_0087C2BA-0653-4F73-B7D9-B2F4EDF37B40'. Operating system error 0x80070002(The system cannot find the file specified.). 5/6/2007 11:38:15 AM: 5/6/2007 11:38:16 AM: Memory profile 5/6/2007 11:38:16 AM: Type Maximum Minimum Average Blk count Total 5/6/2007 11:38:16 AM: 5/6/2007 11:38:16 AM: Commit 792133632 4096 1736286 1031 1790111744 5/6/2007 11:38:16 AM: Reserve 4128768 8192 235049 161 37842944 5/6/2007 11:38:16 AM: Free 160628736 4096 1890316 169 319463424 5/6/2007 11:38:16 AM: Private 792133632 4096 2523230 693 1748598784 5/6/2007 11:38:16 AM: Mapped 1060864 4096 107676 59 6352896 5/6/2007 11:38:16 AM: Image 24707072 4096 165915 440 73003008 5/6/2007 11:38:16 AM: 5/6/2007 11:38:16 AM: 5/6/2007 11:38:16 AM: Warning 300: Backup failed. Retry attempt: 1 5/6/2007 11:38:18 AM: BACKUP DATABASE [TradingAudit] TO DISK = '\\cgsqlba001\prodback\CGSQLARCHI003\diff\DIFF_(local)_Tradindit_20070506_101000_01.sqb', DISK = '\\cgsqlba001\prodback\CGSQLARCHI003\diff\DIFF_(local)_Tradindit_20070506_101000_02.sqb' WITH NAME = 'Database (Tradindit), 5/6/2007 10:10:00 AM', DESCRIPTION = 'Backup on 5/6/2007 10:10:00 AM Server: CGSQLARCHI003 Database: Tradindit', DIFFERENTIAL, INIT, ERASEFILES_ATSTART = 2, COMPRESSION = 2, THREADS = 2 5/6/2007 11:38:18 AM: Thread 0 error: Error 605: Error creating backup file(s). No files could be created. Thread 0 warning: Warning 200: Error creating backup file: \\cgsqlba001\prodback\CGSQLARCHI003\diff\DIFF_(local)_Tradindit_20070506_101000_01.sqb. Warning: System error code: (Not enough server storage is available to process this command) 5/6/2007 11:38:18 AM: Thread 1 error: Error 605: Error creating backup file(s). No files could be created. Thread 1 warning: Warning 200: Error creating backup file: \\cgsqlbak001\prodback\CGSQLARCHI003\diff\DIFF_(local)_Tradindit_20070506_101000_02.sqb. Warning: System error code: (Not enough server storage is available to process this command) 5/6/2007 11:38:19 AM: Server: Msg 3013 BACKUP DATABASE is terminating abnormally. 5/6/2007 11:38:19 AM: Server: Msg 3202 Write on "SQLBACKUP_70F42DF1-F60C-44D5-BA86-CB5E6159923501" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.) 5/6/2007 11:38:19 AM: Server: Msg 3271 A nonrecoverable I/O error occurred on file "SQLBACKUP_70F42DF1-F60C-44D5-BA86-CB5E61599235:" 995(The I/O operation has been aborted because of either a thread exit or an application request.). 5/6/2007 11:38:19 AM: Failed to close vdi. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. sql 2005
Below is the error log, i see it says there isn't enough space.. which there is plenty of free space.. so I'm not sure why it states that.. it hasn't seemed to work correctly since being moved to s...
0 votes
thank you for your answer, now the error makes more sense. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. backup jobs just start failing with error 300
thank you for your answer, now the error makes more sense.
0 votes
that seemed to fix the issue, my question is why do I have to put this on some jobs and not on other that are on the same server? thanks for you help joes / comments
  1. Community
  2. SQL Backup Previous Versions
  3. backup jobs just start failing
that seemed to fix the issue, my question is why do I have to put this on some jobs and not on other that are on the same server? thanks for you help joes
0 votes
here you go thanks SQL Backup log file 11/17/2006 1:02:00 PM: Backing up Quote123 (transaction log) to: \\SQLBAKSTL\PRODBACK\SQLCRIST\LOG_(local)_Quote12_20061117_130200.sqb 11/17/2006 1:02:00 PM: BACKUP LOG [Quote123] TO DISK = '\\SQLBAKST\PRODBACK\SQLCRIST\LOG_(local)_Quote12_20061117_130200.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', ERASEFILES_ATSTART = 23h, COMPRESSION = 2, THREADS = 1 11/17/2006 1:02:02 PM: Deleting old backup file: \\SQLBAKSTL\PRODBACK\SQLCRISTL\LOG_(local)_Quote12_20061116_130200.sqb 11/17/2006 1:02:05 PM: 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: \\SQLBAKSTL\PRODBACK\SQLCRIST\LOG_(local)_Quote12_20061117_130200.sqb Warning: System error code: (Insufficient system resources exist to complete the requested service) 11/17/2006 1:02:05 PM: Server: Msg 3013 BACKUP LOG is terminating abnormally. 11/17/2006 1:02:05 PM: Server: Msg 3202 Write on 'SQLBACKUP_2F97A62D-D62B-44B5-8152-78143C495100' failed, status = 112. See the SQL Server error log for more details. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. backup jobs just start failing
here you go thanks SQL Backup log file 11/17/2006 1:02:00 PM: Backing up Quote123 (transaction log) to: \\SQLBAKSTL\PRODBACK\SQLCRIST\LOG_(local)_Quote12_20061117_130200.sqb 11/17/2006 1:02:00 PM: ...
0 votes
the file doesn't get created.. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. backup jobs just start failing
the file doesn't get created..
0 votes
Total activity
11
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
3