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

Activity overview

Latest activity by CorrinHarris

Increasing the number of files (plus some index maintenance) appears to have done the trick. Thanks. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup failing on large database
Increasing the number of files (plus some index maintenance) appears to have done the trick. Thanks.
0 votes
157GB EACH / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup failing on large database
157GB EACH
0 votes
Backup failing on large database
  1. Community
  2. SQL Backup Previous Versions
I have a large database backup failing (when other databases on the same server to same destination are working). SQL Version SQL2008r2 Enterprise (RTM) results from SP_HELPFILE for sizes.... name ...
2 followers 4 comments 0 votes
SQL Backup Agent restarting unexpectedly....
  1. Community
  2. SQL Backup Previous Versions
We have 2 clustered instances of SQL that can shares nodes. Normally instance A runs on node 1 and instance B runs on node 2. Both have their own Redgate SQL Backup Agent services set up and runnin...
1 follower 1 comment 0 votes
Thanks Petey... We are just in the process of upgrading to 6.5.1.9 and looking at upgrading to 7.2 in the future... / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Issue with MIRROR/VERIFY/PASSWORD combination
Thanks Petey... We are just in the process of upgrading to 6.5.1.9 and looking at upgrading to 7.2 in the future...
0 votes
I have rerun to recreate the issue...it only fails when the combination of MIRROR/PASSWORD/VERIFY is used. Message returned in results set Invalid format specification: '% Processed 272 pages for database 'testdatabase', file 'testdatabase' on file 1. Processed 2 pages for database 'testdatabase', file 'testdatabase_log' on file 1. BACKUP DATABASE successfully processed 274 pages in 0.057 seconds (37.443 MB/sec). Verifying files: \\testserver\BACKUP FOLDER\testdatabase\testdatabase_20121101_14_49_FULL.SQB Error 710: Wrong password entered. Validation of all backup files failed. SQL Backup exit code: 710'. Contents of logfile SQL Backup log file 6.1.0.16 -SQL "BACKUP DATABASE [testdatabase] to DISK='\\testserver\BACKUP FOLDER\<DATABASE>\<DATABASE>_<DATETIME YYYYMMDD_HH_NN>_<TYPE>.SQB' WITH INIT,THREADPRIORITY=2,PASSWORD='XXXXXXXXXX',COMPRESSION=1,MIRRORFILE='\\testserver\BACKUP FOLDER\MIRROR\<DATABASE>\<DATABASE>_<DATETIME YYYYMMDD_HH_NN>_<TYPE>.SQB',VERIFY,SINGLERESULTSET " ERRORS AND WARNINGS 01/11/2012 14:49:45: 01/11/2012 14:49:45: Verifying files: 01/11/2012 14:49:45: \\testserver\BACKUP FOLDER\testdatabase\testdatabase_20121101_14_49_FULL.SQB 01/11/2012 14:49:45: 01/11/2012 14:49:45: Error 710: Wrong password entered. 01/11/2012 14:49:45: Validation of all backup files failed. PROCESSES COMPLETED SUCCESSFULLY 01/11/2012 14:49:44: Backing up testdatabase (full database) to: 01/11/2012 14:49:44: \\testserver\BACKUP FOLDER\testdatabase\testdatabase_20121101_14_49_FULL.SQB 01/11/2012 14:49:44: \\testserver\BACKUP FOLDER\MIRROR\testdatabase\testdatabase_20121101_14_49_FULL.SQB 01/11/2012 14:49:45: BACKUP DATABASE [testdatabase] TO VIRTUAL_DEVICE = 'SQLBACKUP_43C9AC2E-3546-4F3A-8B6D-110A58E4B9DB' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (testdatabase), 01/11/2012 14:49:44', DESCRIPTION = N'Backup on 01/11/2012 14:49:44 Server: testserver Database: testdatabase', FORMAT 01/11/2012 14:49:45: Database size : 8.250 MB 01/11/2012 14:49:45: Compressed data size: 342.500 KB 01/11/2012 14:49:45: Compression rate : 95.95% 01/11/2012 14:49:45: Processed 272 pages for database 'testdatabase', file 'testdatabase' on file 1. 01/11/2012 14:49:45: Processed 2 pages for database 'testdatabase', file 'testdatabase_log' on file 1. 01/11/2012 14:49:45: BACKUP DATABASE successfully processed 274 pages in 0.057 seconds (37.443 MB/sec). / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Issue with MIRROR/VERIFY/PASSWORD combination
I have rerun to recreate the issue...it only fails when the combination of MIRROR/PASSWORD/VERIFY is used. Message returned in results set Invalid format specification: '% Processed 272 pages for ...
0 votes
I have rerun to recreate the issue...it only fails when the combination of MIRROR/PASSWORD/VERIFY is used. Message returned in results set Invalid format specification: '% Processed 272 pages for database 'testdatabase', file 'testdatabase' on file 1. Processed 2 pages for database 'testdatabase', file 'testdatabase_log' on file 1. BACKUP DATABASE successfully processed 274 pages in 0.057 seconds (37.443 MB/sec). Verifying files: \\testserver\BACKUP FOLDER\testdatabase\testdatabase_20121101_14_49_FULL.SQB Error 710: Wrong password entered. Validation of all backup files failed. SQL Backup exit code: 710'. Contents of logfile SQL Backup log file 6.1.0.16 -SQL "BACKUP DATABASE [testdatabase] to DISK='\\testserver\BACKUP FOLDER\<DATABASE>\<DATABASE>_<DATETIME YYYYMMDD_HH_NN>_<TYPE>.SQB' WITH INIT,THREADPRIORITY=2,PASSWORD='XXXXXXXXXX',COMPRESSION=1,MIRRORFILE='\\testserver\BACKUP FOLDER\MIRROR\<DATABASE>\<DATABASE>_<DATETIME YYYYMMDD_HH_NN>_<TYPE>.SQB',VERIFY,SINGLERESULTSET " ERRORS AND WARNINGS 01/11/2012 14:49:45: 01/11/2012 14:49:45: Verifying files: 01/11/2012 14:49:45: \\testserver\BACKUP FOLDER\testdatabase\testdatabase_20121101_14_49_FULL.SQB 01/11/2012 14:49:45: 01/11/2012 14:49:45: Error 710: Wrong password entered. 01/11/2012 14:49:45: Validation of all backup files failed. PROCESSES COMPLETED SUCCESSFULLY 01/11/2012 14:49:44: Backing up testdatabase (full database) to: 01/11/2012 14:49:44: \\testserver\BACKUP FOLDER\testdatabase\testdatabase_20121101_14_49_FULL.SQB 01/11/2012 14:49:44: \\testserver\BACKUP FOLDER\MIRROR\testdatabase\testdatabase_20121101_14_49_FULL.SQB 01/11/2012 14:49:45: BACKUP DATABASE [testdatabase] TO VIRTUAL_DEVICE = 'SQLBACKUP_43C9AC2E-3546-4F3A-8B6D-110A58E4B9DB' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (testdatabase), 01/11/2012 14:49:44', DESCRIPTION = N'Backup on 01/11/2012 14:49:44 Server: testserver Database: testdatabase', FORMAT 01/11/2012 14:49:45: Database size : 8.250 MB 01/11/2012 14:49:45: Compressed data size: 342.500 KB 01/11/2012 14:49:45: Compression rate : 95.95% 01/11/2012 14:49:45: Processed 272 pages for database 'testdatabase', file 'testdatabase' on file 1. 01/11/2012 14:49:45: Processed 2 pages for database 'testdatabase', file 'testdatabase_log' on file 1. 01/11/2012 14:49:45: BACKUP DATABASE successfully processed 274 pages in 0.057 seconds (37.443 MB/sec). / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Issue with MIRROR/VERIFY/PASSWORD combination
I have rerun to recreate the issue...it only fails when the combination of MIRROR/PASSWORD/VERIFY is used. Message returned in results set Invalid format specification: '% Processed 272 pages for ...
0 votes
Its a SQLBackup message (not a sql one) - The following are the full details of what the backup process returns in its result set... Invalid format specification: '% Processed 232 pages for database 'TESTDATABASE', file 'TESTDATABASE' on file 1. Processed 1 pages for database 'TESTDATABASE', file 'TESTDATABASE_log' on file 1. BACKUP DATABASE successfully processed 233 pages in 0.028 seconds (64.871 MB/sec). Verifying files: \\TESTSERVER\BACKUP FOLDER\TESTDATABASE\TESTDATABASE_20121031_12_18_FULL.SQB Error 710: Wrong password entered. Validation of all backup files failed. SQL Backup exit code: 710'. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Issue with MIRROR/VERIFY/PASSWORD combination
Its a SQLBackup message (not a sql one) - The following are the full details of what the backup process returns in its result set... Invalid format specification: '% Processed 232 pages for databas...
0 votes
Issue with MIRROR/VERIFY/PASSWORD combination
  1. Community
  2. SQL Backup Previous Versions
Hi - I may just need help with my syntax - when using MIRROR/VERIFY/PASSWORD combination - I get an 'invalid password' error...below is a list of tests which all work except the last one - any idea...
2 followers 7 comments 0 votes
Total activity
11
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2