Red Gate forums :: View topic - Issue with MIRROR/VERIFY/PASSWORD combination
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 6
SQL Backup 6 forum

Issue with MIRROR/VERIFY/PASSWORD combination

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
CorrinHarris



Joined: 31 Oct 2012
Posts: 9

PostPosted: Wed Oct 31, 2012 2:03 pm    Post subject: Issue with MIRROR/VERIFY/PASSWORD combination Reply with quote

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 ideas? Thanks all!

Oct 31 2012 12:12PM
-SQL "BACKUP DATABASE [TESTDATABASE] to DISK='\\TESTSERVER\BACKUP FOLDER\<DATABASE>\<DATABASE>_<DATETIME YYYYMMDD_HH_NN>_<TYPE>.SQB' WITH INIT,THREADPRIORITY=2,COMPRESSION=1,MIRRORFILE='\\TESTSERVER\BACKUP FOLDER\MIRROR\<DATABASE>\<DATABASE>_<DATETIME YYYYMMDD_HH_NN>_<TYPE>.SQB',VERIFY,SINGLERESULTSET"
Oct 31 2012 12:13PM
-SQL "BACKUP DATABASE [TESTDATABASE] to DISK='\\TESTSERVER\BACKUP FOLDER\<DATABASE>\<DATABASE>_<DATETIME YYYYMMDD_HH_NN>_<TYPE>.SQB' WITH INIT,THREADPRIORITY=2,COMPRESSION=1,MIRRORFILE='\\TESTSERVER\BACKUP FOLDER\MIRROR\<DATABASE>\<DATABASE>_<DATETIME YYYYMMDD_HH_NN>_<TYPE>.SQB',SINGLERESULTSET"
Oct 31 2012 12:14PM
-SQL "BACKUP DATABASE [TESTDATABASE] to DISK='\\TESTSERVER\BACKUP FOLDER\<DATABASE>\<DATABASE>_<DATETIME YYYYMMDD_HH_NN>_<TYPE>.SQB' WITH INIT,THREADPRIORITY=2,COMPRESSION=1,VERIFY,SINGLERESULTSET"
Oct 31 2012 12:15PM
-SQL "BACKUP DATABASE [TESTDATABASE] to DISK='\\TESTSERVER\BACKUP FOLDER\<DATABASE>\<DATABASE>_<DATETIME YYYYMMDD_HH_NN>_<TYPE>.SQB' WITH INIT,THREADPRIORITY=2,COMPRESSION=1,SINGLERESULTSET"
Oct 31 2012 12:15PM
-SQL "BACKUP DATABASE [TESTDATABASE] to DISK='\\TESTSERVER\BACKUP FOLDER\<DATABASE>\<DATABASE>_<DATETIME YYYYMMDD_HH_NN>_<TYPE>.SQB' WITH INIT,THREADPRIORITY=2,PASSWORD='t3stPA88WORD',COMPRESSION=1,SINGLERESULTSET"
Oct 31 2012 12:16PM
-SQL "BACKUP DATABASE [TESTDATABASE] to DISK='\\TESTSERVER\BACKUP FOLDER\<DATABASE>\<DATABASE>_<DATETIME YYYYMMDD_HH_NN>_<TYPE>.SQB' WITH INIT,THREADPRIORITY=2,PASSWORD='t3stPA88WORD',COMPRESSION=1,MIRRORFILE='\\TESTSERVER\BACKUP FOLDER\MIRROR\<DATABASE>\<DATABASE>_<DATETIME YYYYMMDD_HH_NN>_<TYPE>.SQB',SINGLERESULTSET"
Oct 31 2012 12:17PM
-SQL "BACKUP DATABASE [TESTDATABASE] to DISK='\\TESTSERVER\BACKUP FOLDER\<DATABASE>\<DATABASE>_<DATETIME YYYYMMDD_HH_NN>_<TYPE>.SQB' WITH INIT,THREADPRIORITY=2,PASSWORD='t3stPA88WORD',COMPRESSION=1,VERIFY,SINGLERESULTSET"
Oct 31 2012 12:18PM
-SQL "BACKUP DATABASE [TESTDATABASE] to DISK='\\TESTSERVER\BACKUP FOLDER\<DATABASE>\<DATABASE>_<DATETIME YYYYMMDD_HH_NN>_<TYPE>.SQB' WITH INIT,THREADPRIORITY=2,PASSWORD='t3stPA88WORD',COMPRESSION=1,MIRRORFILE='\\TESTSERVER\BACKUP FOLDER\MIRROR\<DATABASE>\<DATABASE>_<DATETIME YYYYMMDD_HH_NN>_<TYPE>.SQB',VERIFY,SINGLERESULTSET"
Msg 2787, Level 16, State 1, Procedure up_take_backup_redgate, Line 160
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'.
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2305

PostPosted: Thu Nov 01, 2012 1:14 pm    Post subject: Reply with quote

Quote:
Msg 2787, Level 16, State 1, Procedure up_take_backup_redgate, Line 160
Invalid format specification: '%


Do you know what this error refers to? Something in your 'up_take_backup_redgate' procedure?
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
CorrinHarris



Joined: 31 Oct 2012
Posts: 9

PostPosted: Thu Nov 01, 2012 2:54 pm    Post subject: Reply with quote

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'.
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2305

PostPosted: Thu Nov 01, 2012 3:25 pm    Post subject: Reply with quote

SQL Backup generates a log file for each process that it runs. The default folder where the logs are stored is C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name> on Windows 2003 and older, and C:\ProgramData\Red Gate\SQL Backup\Log\<instance name> on Windows Vista and newer.

Could you please post the contents of the log file for the backup that raised the error?

Thanks.
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
CorrinHarris



Joined: 31 Oct 2012
Posts: 9

PostPosted: Thu Nov 01, 2012 3:55 pm    Post subject: Reply with quote

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).
Back to top
View user's profile Send private message
CorrinHarris



Joined: 31 Oct 2012
Posts: 9

PostPosted: Thu Nov 01, 2012 3:57 pm    Post subject: Reply with quote

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).
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2305

PostPosted: Thu Nov 01, 2012 4:19 pm    Post subject: Reply with quote

The issue you are encountering was a bug in version 6.1, and was fixed in 6.3. However, I would suggest upgrading to version 6.5, as it contains fixes for other issues for the version 6 release.

If you have an active maintenance contract, you could upgrade to version 7 instead.
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
CorrinHarris



Joined: 31 Oct 2012
Posts: 9

PostPosted: Thu Nov 01, 2012 4:25 pm    Post subject: Reply with quote

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...
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group