SQL restore job fails with the error "The database to be restored was named 'Database1'. Reissue the statement using the WITH REPLACE option to overwrite the 'Database2' database

Article:TECH128844  |  Created: 2010-01-15  |  Updated: 2013-04-09  |  Article URL http://www.symantec.com/docs/TECH128844
Article Type
Technical Solution


Subject

Issue



SQL restore job fails with the error "The database to be restored was named 'Database1'. Reissue the statement using the WITH REPLACE option to overwrite the 'Database2' database


Error



V-79-65323-3141

V-79-65323-3142

The database to be restored was named 'dB1'. Reissue the statement using the WITH REPLACE option to overwrite the 'dB2' database.
V-79-57344-33938 - The database to be restored was named 'dB1'. Reissue the statement using the WITH REPLACE option to overwrite the 'dB2' database.

 


Cause



Redirected SQL restore to different server with a different name fails with the above errors due to insufficient administrator rights and permissions for the backup account on the SQL instance of the destination SQL server.
 
 

Solution



To redirect SQL restores, the following conditions must be met:
 
Warning: Incorrect use of the Windows registry editor may prevent the operating system from functioning properly. Great care should be taken when making changes to a Windows registry. Registry modifications should only be carried-out by persons experienced in the use of the registry editor application. It is recommended that a complete backup of the registry and workstation be made prior to making any registry changes.
 
 1) Backup Exec account should have full administrator access to these registry keys:
 
 HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
 
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
 
 2) The target SQL instance should have the same Service pack level as the SQL Instance that was backed up.
3) The target SQL instance should have the account used for restore added to the security permissions with sysadmin server roles.
      Refer: http://www.symantec.com/docs/TECH87628 
 

 Perform the following steps :
 
1) Create a new SQL database on the target sql instance.
2) Select the SQL redirect option in the restore job properties and mention the new database name.
3) Select the option to overwrite existing database.
4) Run the restore job again which will overwrite the new database.

 

Supplemental Materials

SourceUMI
ValueV-79-65323-3141
Description

The database to be restored was named 'dBname1'. Reissue the statement using the WITH REPLACE option to overwrite the 'dBname2' database


SourceUMI
ValueV-79-57344-33938
Description

The database to be restored was named 'dBname1'. Reissue the statement using the WITH REPLACE option to overwrite the 'dBname2' database


SourceUMI
ValueV-79-65323-3142
Description

The database to be restored was named 'dBname1'. Reissue the statement using the WITH REPLACE option to overwrite the 'dBname2' database



Legacy ID



350369


Article URL http://www.symantec.com/docs/TECH128844


Terms of use for this information are found in Legal Notices