cancel
Showing results for 
Search instead for 
Did you mean: 
theseng99
Level 4

This is my first article on symantec connect. Many people know how to backup data, file but when their server goes down they don't know how to restore the database, and email at that time. I think we need to study further on the restore solution.

This article is to describe about redirecting and restoring SQL Database to another machine or another instance.

Let's begin.

Note: Symantec Backup exec 12.5 SP3 and destination server needed to install Agent.

Step 1 : Open Restore Job and go to Source -> Selections then select your file that want to restore. Example select on DBSallc SQL Database. 

 

Step 2 : Go to Source -> Device then select Device and choose your device name.

 

Step 3 : Go to Destination -> Microsoft SQL Redirection. this step you need to insert some field that is important when restore.

Redirect Microsoft SQL Server sets for enable redirect restore.

  • Destination -> Server  this field you need to input destination hostname. in Example is SQLDB1 (Servername)
  • Destination -> Server -> Instance this field you have to input destination instance name (If you leave it, it will input default instance on that destination server)
  • Destination -> Server -> Instance -> Database this file is not require. the name of database should not duplicate database name on destination server.

Destination Option

  • Use alternate drive this field you can select drive that want to be restore.
  • only when original drive does not exist that mean it will restore to alternate drive when original drive does not exitst. if it exist, it will not restore to alternate drive.
  • even when original drive does exist that mean it will restore to alternate drive that you selected in any case.
  • Use destination instance's default data directory that mean it will restore to instance default data directory. Example if that instance DB path you backup keep on C:\Database it will restore to C:\Database on destination server also.
  • Use this path you can specify path that will redirect restore on destination server.

Tip : In my experience, I always select Use alternate drive because of it is easy to manage. you don't need to set many thing. the important is you just need to restore SQL Database to destination server first then you can move it to anywhere.

and you can test this config by click check selections

 

 

Step 4 : This menu I leave it default. and then click restore. you will got database that you backup on new destination server.

Hope you will successful about restoring SQL Database to another server.

Good luck!!

Andy.

Comments
Zahid_Haseeb
Moderator
Moderator
Partner    VIP    Accredited

I have also written an article to restore for SQL via Netbackup Server. i think ppl also find this interesting when they got SQL backup and Restore via Exec and Netbackup :)

 

https://www-secure.symantec.com/connect/articles/how-backup-and-restore-microsoft-sql-server-backup-...

CraigV
Moderator
Moderator
Partner    VIP    Accredited

...just 1 thing...you should highlight the various options that are available for restoring.

Some people might take the first option as you have shown, and they might end up with 2 live versions of the same DB (if the primary DB is still online!!!)...

ziggy
Level 3

Good article. Thank you. The above comments were helpful as well.

Tim_A
Level 0

I have a problem with a database. I need to restore the original database to a test database. The name of my test database is LOCAL. It is on the same server. How can I do this?

Also, Can I restore the database to a new database for test? How do I rename it?

Thanks.

boyturon
Not applicable

I have a problem on database restore. Here is the error message.

 

"The job failed with the following error: Unable to attach to a resource.  Make sure that all selected resources exist and are online, and then try again.  If the server or resource no longer exists, remove it from the selection list. Edit the selection list properties, click the View Selection Details tab, and then remove the resource."

hope you can help me,

 

THank you.

 

 

kakagol
Level 4

Hello all,

Instead of redirect restoring a DB to SQL , is there any way I can restore the DB as a file to a location?Using "File Redirection" instead of using "MS SQL Redirection"?

This is the error I receive when running restore with this second option

The job failed with the following error: A hardware error occurred.

 

PLease help, thanks in advance.

 

Jaydeep_S
Level 6
Employee Accredited Certified

Unfortunately no. A SQL database can only be restored on a SQL instance using Backup Exec, it cannot be redirected to a file system

Webgenie
Not applicable

Great article.

I'd like to restore SQL 2008 R2 databses to a different SQL 2008 R2 server with the same database name and same database locations\paths as source server.

Source database files are stored under G:\Apps\MSSQL10_50.MSSQLSERVER\MSSQL\DATA

and I'd like target database files to be restored on the same path on target server.

 

Which Microsoft SQL Redirection options I must select for this purpose in Backup Exec 2010 ?

 

  • Use destination instance's default data directory

               or

  • Use this path G:\Apps\MSSQL10_50.MSSQLSERVER\MSSQL\DATA

 

 

Can someone please help ?

 

Version history
Last update:
‎10-19-2010 10:21 AM
Updated by: