Competition: What’s your favorite Redgate tool? Enter now.

Issue with MIRROR/VERIFY/PASSWORD combination

CorrinHarrisCorrinHarris Posts: 12
edited November 1, 2012 11:25AM in 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 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'.

Comments

  • peteypetey Posts: 2,358 New member
    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 8
  • 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'.
  • peteypetey Posts: 2,358 New member
    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 8
  • 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).
  • 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).
  • peteypetey Posts: 2,358 New member
    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 8
  • 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...
Sign In or Register to comment.