截屏视频帮助
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Restore I : Redirect Restore SQL Database to Another machine

创建时间: 19 10 月 2010 | 8 条评论
theseng99 的图片
+2 2 Votes
Login to vote

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.

评论 条评论跳转至最新评论

Zahid.Haseeb 的图片

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-netbackup

Any comment will be appreciated. Mark as Solution if your query is resolved
__________________
Thanks in Advance
Zahid Haseeb

zahidhaseeb.wordpress.com

-1
Login to vote
CraigV 的图片

...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!!!)...

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...

0
Login to vote
ziggy 的图片

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

0
Login to vote
Tim_A 的图片

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.

0
Login to vote
boyturon 的图片

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 的图片

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.

0
Login to vote
Jaydeep S 的图片

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

+1
Login to vote
Webgenie 的图片

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 ?

0
Login to vote