cancel
Showing results for 
Search instead for 
Did you mean: 

Restore SQL2008R2 database to SQL 2012 failed

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

Tags (2)
5 Replies

Re: Restore SQL2008R2 database to SQL 2012 failed

Cross-version restore for SQL is a question for Microsoft.

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

Re: Restore SQL2008R2 database to SQL 2012 failed

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

Re: Restore SQL2008R2 database to SQL 2012 failed

@Michal_Mikulik1Thank you

I Attached the dbclient log with logging level 5

Re: Restore SQL2008R2 database to SQL 2012 failed

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

Re: Restore SQL2008R2 database to SQL 2012 failed

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 ?