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
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.
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.
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 ?