User profile for chrisflint

Any update, I've loaded the patch given by support but still run into the same issues. Ver 3.2.0.4, dated 8/18 Still same issue. / comments

Any update, I've loaded the patch given by support but still run into the same issues. Ver 3.2.0.4, dated 8/18 Still same issue.

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, &#4...

0 votes

Update: I am able to do splits to the same locations as before if I use the Command-line version. [image] (Really not the solution I am looking for...) Answers to your questions: My previous tests using the Stored Procedure, I was using UNC paths to the server itself, as well as other locations, neither worked for splitting. For example I have a server named SQL2. Split files to c:\temp worked, Split files to \\sql2\c$\temp do not. I also tried creating different shares other than admin shares, etc. This does not change the end result. Same thing with the remote server, not using file splitting let the backup complete correctly. This server and also the remote server do not have AV. / comments

Update: I am able to do splits to the same locations as before if I use the Command-line version. (Really not the solution I am looking for...)Answers to your questions: My previous tests using t...

0 votes

I haven't been able to get the stored procedures to run. I also tried running regsvr32 against the dll, but didn't work. I always get the same error in Query Analyzer: ODBC: Msg 0, Level 16, State 1 Cannot load the DLL xp_sqlbackup.dll, or one of the DLLs it references. Reason: 193(error not found). I went in to the master, extended stored procedure, and tried setting the path to the DLL as well but it just appends the path then I get the error: ODBC: Msg 0, Level 16, State 1 Cannot load the DLL C:\Program Files (x86)\Red Gate\SQL Backup\xp_sqlbackup.dll, or one of the DLLs it references. Reason: 193(error not found). I was able to get the command-line to work correctly. 8) Will work until the rest is fixed. / comments

I haven't been able to get the stored procedures to run. I also tried running regsvr32 against the dll, but didn't work. I always get the same error in Query Analyzer:ODBC: Msg 0, Level 16, State...

0 votes

Yes both files are created, one I'm guessing is exactly half the full backup, what it should be. The other is very small. Has some control characters when opened with notepad. FULL_SQL2_imagenow_09_20050725 154155_1.sqb 3,980,288 bytes FULL_SQL2_imagenow_09_20050725 154155_2.sqb 512 bytes / comments

Yes both files are created, one I'm guessing is exactly half the full backup, what it should be. The other is very small. Has some control characters when opened with notepad. FULL_SQL2_imagenow_...

0 votes

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

Yes, the permissions are correct. The process works when I do not use file splitting. Also the same path is being used by the Service Account I use that is SQL Server + Agent. I've logged in with it as well to test it, still same errors. The issue seems to be with file splitting, which would give be better performance, for now I'm suffering some, backup times are double what they should be, but still better than native SQL backup. / comments

Yes, the permissions are correct. The process works when I do not use file splitting. Also the same path is being used by the Service Account I use that is SQL Server + Agent. I've logged in wit...

0 votes

Can someone post the results of this :?: I've got a case where I cannot use file splitting to a UNC path. Works locally fine. This is with the wizard right now. I've found nothing on Google or I don't have the right keywords. Thanks in advance! / comments

Can someone post the results of this :?: I've got a case where I cannot use file splitting to a UNC path. Works locally fine. This is with the wizard right now. I've found nothing on Google or...

0 votes

64-bit Support?

Does SQL Backup support 64-bit platforms (i.e. Win 2003 ia64)? If not, how about with the IA-32 Execution Layer add-in? I just ordered 10 licenses w/support and the only thing listed on the websi...

6 followers 10 comments 0 votes

How can we help you today?

chrisflint

Activity overview