cancel
Showing results for 
Search instead for 
Did you mean: 

Restore SQL2008R2 database to SQL 2012 failed

POGY
Level 4

Hi

Is there a limitation to restore SQL to diffrent version?

I tried to restore SQL 2008R2 database to SQL 2012 by using the move script but it always fail

I also tried to restore SQL 2012 database to SQL 2014 and it failed to.

I double cheked all permission, NetBackup service account is running with saadmin and local admin account.

same  user configured in the NetBackup SQL client

Full Backup is taken with no problem

I tried many times to troubleshoot restore but always restore failes.

Where is what I do

1- Connect to the destination server and make sure service account run with local admin and saadmin account

2- Set same user account in the NetBackup SQL client

3- Create restore script with move type restore

4- edit the script

5- Run script

I did restore with move template to the same version it successfully complete.

So my question is there any limitation to redirect restore SQL database to diffrent SQL version

Thank you

5 REPLIES 5

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
Cross-version restore for SQL is a question for Microsoft.

I do not believe that Veritas/NBU has a documented limitation on this.

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

Hello,

yes SQL restores to higher versions are supported.

Can you provide us restore log with a more detailed error? I guess there will be some problem with MOVE phrase.

Regards

Michal

@Michal_Mikulik1Thank you

I Attached the dbclient log with logging level 5

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

Hello,

something wrong is with the target folder existence/permission:


21:49:02.269 [3896.4556] <16> CODBCaccess::LogODBCerr: DBMS MSG - SQL Message <3156><[Microsoft][SQL Server Native Client 11.0][SQL Server]File 'AdventureWorks2008R2_Log' cannot be restored to 'C:\Program Files\Microsoft SQL Server\NBU_Restore\DB\AdventureWorks2008R2_log.LDF'. Use WITH MOVE to identify a valid location for the file.>

the same for .MDF file.

regards

Michal

Also Please check eventviewer on target host for the same time period.

DOes it show any error message ?

and has it written something or not ?

What is version of Netbackup client on target host ? is it compatible with version of SQL ?