Redirected restore of MS SQL database.

Question

Hi&nbsp;

it is just for a clearity:

In case of redirected restore of any SQL database from NBU for MSSQL:

1) can I restore to aleternate client having different version of SQL.
	2) Is it possible to restore to other client with same diffrent version of Windows &amp; SQL.
	3) what if version of NBU client is also diffrent.

marianne · Accepted Answer

SQL server 2014 is only supported as from NBU 7.6.0.3. 
Restore should work if target is on correct, supported NBU version.

Just double check that Microsoft supports restores from version 2012 to 2014.

inn_kam · Answer

&nbsp;

NetBackup for Microsoft SQL Server: Performing a database move to the same SQLHOST or to an alternate SQLHOST

Article:TECH35995
				&nbsp;|&nbsp;
				Created: 2004-01-09
				&nbsp;|&nbsp;
				Updated: 2013-10-24
				&nbsp;|&nbsp;
				
					Article URL&nbsp;http://www.symantec.com/docs/TECH35995
						
						&nbsp;

&nbsp;

https://www-secure.symantec.com/connect/forums/restoration-msql-db-instance-servera-serverb

&nbsp;

&nbsp;
	DOCUMENTATION: Step-by-step procedure for using NetBackup to restore a Microsoft SQL Full Backup using a MOVE script

Article:TECH51062
				&nbsp;|&nbsp;
				Created: 2007-01-08
				&nbsp;|&nbsp;
				Updated: 2010-01-02
				&nbsp;|&nbsp;
				
					Article URL&nbsp;http://www.symantec.com/docs/TECH51062
						
						&nbsp;

&nbsp;

DOCUMENTATION: Step-by-step procedure for using NetBackup to restore a Microsoft SQL Full Backup using a MOVE script

Article:TECH51062
			&nbsp;|&nbsp;
			Created: 2007-01-08
			&nbsp;|&nbsp;
			Updated: 2010-01-02
			&nbsp;|&nbsp;
			Article URL&nbsp;http://www.symantec.com/docs/TECH51062

&nbsp;

&nbsp;
	&nbsp;

inn_kam · Answer

1.

https://www-secure.symantec.com/connect/forums/restore-sql-transaction-log-along-database-different-sql-server#comment-10317631.

Where did you try to start the restore?

It must be done on the destination client where you want to restore to.

You first have to authorize redirected restore on the master by creating altnames files or else No.Restrictions touch file.

See 'Redirecting a restore to a different host' &nbsp;in&nbsp;NetBackup for Microsoft SQL Server Administrator's Guide: &nbsp;http://www.symantec.com/docs/DOC5173&nbsp;

Please also ensure that you have NBU 7.5.0.5 or later installed on the SQL servers - there were bugs/issues with erlier 7.5 patch levels.

&nbsp;

https://www-secure.symantec.com/connect/forums/netbackup-sql-restore-different-hostpath-and-instance#comment-9697891

Log on to the server where you want to restore (SAOS00506006) and run it from there.

BROWSECLIENT&nbsp;&nbsp; 'Restores images from a host other than the local host.'

so it must point to the original server&nbsp;

also change

TO&nbsp; "F:\MSSQL\DataATLAS_log.ldf"

to

TO&nbsp; "F:\MSSQL\Data\ATLAS_log.ldf"

(missing backslash)

and make sure the path F:\MSSQL\Data\ exists on SAOS00506006

Will Restore -- where there is a Will there is a way

2.https://www-secure.symantec.com/connect/forums/regarding-sql-restore#comment-9162871

...my Source SQL server is on 2008 version and Destination SQL Server is on 2005 version .....

I cannot imagine that this will be supported by Microsoft. Probably the reason for the error we see in above output:

&nbsp;

https://www-secure.symantec.com/connect/forums/netbackup-cannot-browse-or-restore-sql-client-backups#comment-9687851

When you browse for restores, the SQL server will send its local hostname as Source Client to the master.

When you modify the hostname in the SQL Client GUI to the Virtual name, it sends the following to the master server:
	Client&nbsp;ETCCSPCLDB2 is requesting backup images for Client&nbsp;ETCCSPCLDB.

The master treats these names as totally different Client names (i.e. redirected restore).
	Now, in NBU, client restore of a different client name is not allowed by default.&nbsp;
	You need to add altnames files to allow client to perform redirected restore.

All of this is documented in NBU for SQL Admin Guide:&nbsp;http://www.symantec.com/docs/DOC5173&nbsp;

See&nbsp;Redirecting a restore to a different host&nbsp;
	and&nbsp;Performing a restore on a virtual SQL Server instance

Hope this helps.

Supporting Storage&nbsp;

&nbsp;

inn_kam · Answer

3. NBU Client which version to which version

and SQL which version to which version

u have to check the compaitibility&nbsp;

NetBackup 7.x Database Agent Compatibility List

Article:TECH126904
			&nbsp;|&nbsp;
			Created: 2010-01-13
			&nbsp;|&nbsp;
			Updated: 2014-11-19
			&nbsp;|&nbsp;
			Article URL&nbsp;http://www.symantec.com/docs/TECH126904
				&nbsp;

nbu35 · Answer

Hi Inn_Kam

Thanks for your replies, but I am still struggling to get an concrete answer.

As per my understanding from last technote (DB ACL)

1) can I restore to aleternate client having different version of SQL.

It is only possible to restore to other client with different SQL version (provided target SQL server has more latest version of SQL server in comparison to source SQL server).
	&nbsp;

2) Is it possible to restore to other client with same diffrent version of Windows &amp; SQL.

It is possible to restore provided that windows &amp; SQL server version is supported &amp; keeping 1st point in mind.

&nbsp;
	3) what if version of NBU client is also diffrent.

It is possible.

kindly suggest if there is anything which is wrong as per my assumption in this case .

inn_kam · Answer

Hi champ

as per concrete answer ,one must clear the versions of SQL and NB&nbsp;

Forum Discussion

Redirected restore of MS SQL database.

11 Replies

Related Content

oracle Database redirect restore error

Oracle database restore from vmware type backup

Re: Netbackup windows folder restore to different server

Re: How I restore Hyper-v VM in a different location

SAP redirected database restore using brrestore/rman_util failing

Recent Discussions

command: bperror

MS-SharePoint policy restore error (2804) .

How to restore a backup

How to configure RBAC

10 years old netbackup appliance database service down, ssl certification out date