Restoring SQL

Hi,

You can try a restore to a folder, but you can also restore to another SQL DB. There is an option to not mount the DB after the restore, and keep it offline.

Check the TNs below for further information:

http://www.symantec.com/business/support/index?page=content&id=HOWTO24045

http://www.symantec.com/business/support/index?page=content&id=TECH56694

Thanks!

Hi crauv,

Can we restore the DBs on any parition of the disks and to reattach it later on to an SQL server

do  you have any ideas how it works?

You would have the option to restore to a disk if need be. Best bet is to read those 2 links, along with the Admin Guide...

EDIT: Check the second link...try the following options:

1. Microsoft SQL Redirection --> Redirect SQL Restore

2. Tick "Server" and type in the name. Make sure nothing else shows up.

3. Click "Destination Options" --> Use this path. Put in the details.

Try that on a non-SQL server first and see if it works. If you get the necessary SQL files, you should be good to go afterwards.

Hi Again

I tried this and got the following error:

Final error: 0xe000848c - 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. Final error category: Resource Errors

Without specifying the server i got a message that i have to check also the option overwrite existing database. I did and it didnt work also.

I want to restore these databases and take them on a usb, i will attach them later on to a different database, Is there a way to do it ?

Thanks

You have to specify the server, and it has to be running a RAWS agent...either locally, or on a remote server.

The server i have specified is the local Backup Exec Server

Put in the local server's name and put in a drive and see if it works.

The other option is to install SQL on the media server (make sure it doesn't clash with SQL Express at all), and do a redirected SQL restore to this. Once done, detach the DB, copy to the USB stick and take to your other site before uninstalling SQL.

First option didnt work.. So Backup Exec can only restore to an SQL database(local or remote SQL Servers) but it cannot restore to a folder as .mdf or .ldf to be attached later one to different databases.