How can we help you today? How can we help you today?
chrisflint
Here is the log file when I try to split, at the bottom is when I do a single file: 7/25/2005 3:41:55 PM: SQL Backup 3.2.0, (c) Red Gate Software Ltd 2004 - 2005 7/25/2005 3:41:55 PM: 7/25/2005 3:41:55 PM: Backing up imagenow_09 (full database) to \\sql2\c$\temp\FULL_SQL2_imagenow_09_20050725 154155_1.sqb, \\sql2\c$\temp\FULL_SQL2_imagenow_09_20050725 154155_2.sqb ... 7/25/2005 3:41:55 PM: 7/25/2005 3:41:55 PM: BACKUP DATABASE [imagenow_09] TO DISK = '\\sql2\c$\temp\FULL_SQL2_imagenow_09_20050725 154155_1.sqb', DISK = '\\sql2\c$\temp\FULL_SQL2_imagenow_09_20050725 154155_2.sqb' WITH NAME = 'db (imagenow_09)', DESCRIPTION = 'Backup of Database: imagenow_09 Instance: (local) Server: SQL2', INIT, ERASEFILES = 7, COMPRESSION = 2 7/25/2005 3:41:55 PM: 7/25/2005 3:41:55 PM: osql -S SQL2 -i "C:\DOCUME~1\sa-sql\LOCALS~1\Temp\sqbi410507251541599.txt" -b -w 120 -U sa -P XXXXXXXXXX 7/25/2005 3:42:01 PM: Thread 1 error: Error 620: Error writing to backup file(s). Thread 1 warning: Warning 610: Error writing to backup file: \\sql2\c$\temp\FULL_SQL2_imagenow_09_20050725 154155_2.sqb Warning: System error code: (Insufficient system resources exist to complete the requested service) 7/25/2005 3:42:01 PM: Backup data size : 20.375 MB 7/25/2005 3:42:01 PM: Compressed data size: 3.796 MB 7/25/2005 3:42:01 PM: Compression rate : 81.37% Processed 1752 pages for database 'imagenow_09', file 'imagenow_09_data' on file 1. Processed 3288 pages for database 'imagenow_09', file 'imagenow_09_index' on file 1. Processed 1 pages for database 'imagenow_09', file 'imagenow_09_log' on file 1. BACKUP DATABASE successfully processed 5041 pages in 3.224 seconds (12.806 MB/sec).[/size] 7/25/2005 3:35:35 PM: SQL Backup 3.2.0, (c) Red Gate Software Ltd 2004 - 2005 7/25/2005 3:35:35 PM: 7/25/2005 3:35:35 PM: Backing up imagenow_09 (full database) to \\sql2\c$\temp\FULL_SQL2_imagenow_09_20050725 153535.sqb ... 7/25/2005 3:35:35 PM: 7/25/2005 3:35:35 PM: BACKUP DATABASE [imagenow_09] TO DISK = '\\sql2\c$\temp\FULL_SQL2_imagenow_09_20050725 153535.sqb' WITH NAME = 'Database (imagenow_09)', DESCRIPTION = 'Backup of Database: imagenow_09 Instance: (local) Server: SQL2', INIT, ERASEFILES = 7, COMPRESSION = 2 7/25/2005 3:35:35 PM: 7/25/2005 3:35:35 PM: osql -S SQL2 -i "C:\DOCUME~1\sa-sql\LOCALS~1\Temp\sqbi350507251535971.txt" -b -w 120 -U sa -P XXXXXXXXXX 7/25/2005 3:35:40 PM: Backup data size : 40.063 MB 7/25/2005 3:35:40 PM: Compressed data size: 7.525 MB 7/25/2005 3:35:40 PM: Compression rate : 81.22% 7/25/2005 3:35:43 PM: Process completed successfully. 7/25/2005 3:35:43 PM: Processed 1752 pages for database 'imagenow_09', file 'imagenow_09_data' on file 1. Processed 3288 pages for database 'imagenow_09', file 'imagenow_09_index' on file 1. Processed 1 pages for database 'imagenow_09', file 'imagenow_09_log' on file 1. BACKUP DATABASE successfully processed 5041 pages in 2.844 seconds (14.517 MB/sec). (1 row affected) Thanks so much for all your help!! [image] / comments
Here is the log file when I try to split, at the bottom is when I do a single file:7/25/2005 3:41:55 PM: SQL Backup 3.2.0, (c) Red Gate Software Ltd 2004 - 2005 7/25/2005 3:41:55 PM: 7/25...
0 votes
Any updates on support for ia64 platforms? My x64 stuff works fine, but it is the Enterprise level Itanium servers where I need the product the most. / comments
Any updates on support for ia64 platforms? My x64 stuff works fine, but it is the Enterprise level Itanium servers where I need the product the most.
0 votes
Any ideas what makes this happen. I'm getting the same issue, random times. This isn't the only database, can happen when doing transaction logs, etc. 7/29/2005 12:00:01 AM: SQL Backup 3.2.0, (c) Red Gate Software Ltd 2004 - 2005 7/29/2005 12:00:01 AM: 7/29/2005 12:00:01 AM: Backing up 35_live (full database) to \\bbes\e$\sqlbackup\maintplan\sql\35_live\FULL_(local)_35_live_20050729 000001_1.sqb, \\bbes\e$\sqlbackup\maintplan\sql\35_live\FULL_(local)_35_live_20050729 000001_2.sqb, \\bbes\e$\sqlbackup\maintplan\sql\35_live\FULL_(local)_35_live_20050729 000001_3.sqb ... 7/29/2005 12:00:01 AM: 7/29/2005 12:00:01 AM: BACKUP DATABASE [35_live] TO DISK = '\\bbes\e$\sqlbackup\maintplan\sql\35_live\FULL_(local)_35_live_20050729 000001_1.sqb', DISK = '\\bbes\e$\sqlbackup\maintplan\sql\35_live\FULL_(local)_35_live_20050729 000001_2.sqb', DISK = '\\bbes\e$\sqlbackup\maintplan\sql\35_live\FULL_(local)_35_live_20050729 000001_3.sqb' WITH NAME = 'Database', DESCRIPTION = '', INIT, ERASEFILES = 7, COMPRESSION = 2 7/29/2005 12:00:01 AM: 7/29/2005 12:00:03 AM: VDI error 1000: Failed to create virtual device. Check that the SQL Server instance you are trying to connect to is running. Error code: -2147024891 () 7/29/2005 12:00:03 AM: Access is denied And again same error tonight 7/30/2005 12:00:01 AM: SQL Backup 3.2.0, (c) Red Gate Software Ltd 2004 - 2005 7/30/2005 12:00:01 AM: 7/30/2005 12:00:01 AM: Backing up 35_live (full database) to \\bbes\e$\sqlbackup\maintplan\sql\35_live\FULL_(local)_35_live_20050730 000001_1.sqb, \\bbes\e$\sqlbackup\maintplan\sql\35_live\FULL_(local)_35_live_20050730 000001_2.sqb, \\bbes\e$\sqlbackup\maintplan\sql\35_live\FULL_(local)_35_live_20050730 000001_3.sqb ... 7/30/2005 12:00:01 AM: 7/30/2005 12:00:01 AM: BACKUP DATABASE [35_live] TO DISK = '\\bbes\e$\sqlbackup\maintplan\sql\35_live\FULL_(local)_35_live_20050730 000001_1.sqb', DISK = '\\bbes\e$\sqlbackup\maintplan\sql\35_live\FULL_(local)_35_live_20050730 000001_2.sqb', DISK = '\\bbes\e$\sqlbackup\maintplan\sql\35_live\FULL_(local)_35_live_20050730 000001_3.sqb' WITH NAME = 'Database', DESCRIPTION = '', INIT, ERASEFILES = 7, COMPRESSION = 2 7/30/2005 12:00:01 AM: 7/30/2005 12:00:03 AM: VDI error 1000: Failed to create virtual device. Check that the SQL Server instance you are trying to connect to is running. Error code: -2147024891 () 7/30/2005 12:00:03 AM: Access is denied I'm read the previous recommendations, vdi.log does not exist anywhere on my machine. This is my script that runs nightly as a service account that has admin privledges: @ECHO OFF c: cd "\Program Files (x86)\Red Gate\SQL Backup\" SQLBackupC.exe -SQL "BACKUP DATABASE [35_live] TO DISK='\\bbes\e$\sqlbackup\maintplan\sql\35_live\<AUTO>_1', DISK='\\bbes\e$\sqlbackup\maintplan\sql\35_live\<AUTO>_2', DISK='\\bbes\e$\sqlbackup\maintplan\sql\35_live\<AUTO>_3' WITH NAME ='Database', INIT, ERASEFILES = 7, COMPRESSION=2" >>C:\SCRIPTS\LOG\full_live_35.LOG EXIT I just ran it with the same user ID, ran my batch file and it worked correctly. 7/30/2005 12:27:18 AM: SQL Backup 3.2.0, (c) Red Gate Software Ltd 2004 - 2005 7/30/2005 12:27:18 AM: 7/30/2005 12:27:18 AM: Backing up 35_live (full database) to \\bbes\e$\sqlbackup\maintplan\sql\35_live\FULL_(local)_35_live_20050730 002718_1.sqb, \\bbes\e$\sqlbackup\maintplan\sql\35_live\FULL_(local)_35_live_20050730 002718_2.sqb, \\bbes\e$\sqlbackup\maintplan\sql\35_live\FULL_(local)_35_live_20050730 002718_3.sqb ... 7/30/2005 12:27:18 AM: 7/30/2005 12:27:18 AM: BACKUP DATABASE [35_live] TO DISK = '\\bbes\e$\sqlbackup\maintplan\sql\35_live\FULL_(local)_35_live_20050730 002718_1.sqb', DISK = '\\bbes\e$\sqlbackup\maintplan\sql\35_live\FULL_(local)_35_live_20050730 002718_2.sqb', DISK = '\\bbes\e$\sqlbackup\maintplan\sql\35_live\FULL_(local)_35_live_20050730 002718_3.sqb' WITH NAME = 'Database', DESCRIPTION = '', INIT, ERASEFILES = 7, COMPRESSION = 2 7/30/2005 12:27:18 AM: 7/30/2005 12:27:19 AM: 7/30/2005 12:29:30 AM: Backup data size : 3.623 GB 7/30/2005 12:29:30 AM: Compressed data size: 756.338 MB 7/30/2005 12:29:30 AM: Compression rate : 79.61% 7/30/2005 12:29:34 AM: Process completed successfully. 7/30/2005 12:29:34 AM: Processed 320880 pages for database '35_live', file 'c2000lite_Data' on file 1. Processed 118328 pages for database '35_live', file 'C2000_Index' on file 1. Processed 34504 pages for database '35_live', file 'C2000_CmEvent' on file 1. Processed 8 pages for database '35_live', file 'C2000_CmEventHistory' on file 1. Processed 2 pages for database '35_live', file 'c2000lite_Log' on file 1. BACKUP DATABASE successfully processed 473722 pages in 125.326 seconds (30.965 MB/sec). (1 row affected) Server: HP Integrity rx7620 OS: Windows 2003 Enterprise Edition Procs: 4 x Itanium 2 1.5GHz Mem: 16GB Any ideas, having missing transaction logs and full nightly backups is not reliable to me. :?: / comments
Any ideas what makes this happen. I'm getting the same issue, random times. This isn't the only database, can happen when doing transaction logs, etc.7/29/2005 12:00:01 AM: SQL Backup 3.2.0, &#4...
0 votes