on 10-19-2010 10:21 AM
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 Option
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.
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 :)
...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!!!)...
Good article. Thank you. The above comments were helpful as well.
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.
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.
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.
Unfortunately no. A SQL database can only be restored on a SQL instance using Backup Exec, it cannot be redirected to a file system
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 ?
or
Can someone please help ?