How are you redirecting the SQL databas restoration?

Can you give me steps which you are following......

Redirect the SQL with the SQL optcion to another dabase name.

To redirect SQL database restoration follow the steps mentioned below

1. Create the SQL data base instance with same name (if the sql server is different else anothe database name on the same server)
2. Select the data backup which need to be restore from restore tab
3. In the destination, select SQL redirection tab
4. Check Redirect Microsoft SQL erver sets
5. Check the server andmentioned the server name (As per the conditions mentioned in step 1)
6. Check database and mention database name (As per the conditions mentioned in step 1)
7. Select use this path option and mention the path of the database which you have created before restoration
8. In settings, click on the Microsoft SQL and check Overwrite the existing database box
9. Run the restoration job

Please find attached snapshot for your referance.

Andrew can you attach the job log to your post so I can look into it further?

When you redirect the job on "Microsoft SQL Redirecttion" under Destination on the right pane uncheck "Database" option after on "destination options" select an alternative drive Like a D: drive and check "even whe the original drive does not exist"

attach the screenshot

i'm trying restore the db file in the backup server and no in the Databse server ..

Please check by defining Server name & Database name

I think it will be required...

Please confirm

but if setup the Server name & database name have not sense ... if i want redirect the restore db in an another path ..
try ..

Hi Andrew

The path in the snapshot is located on same SQL server or anywhere else? If somewhere then have u installed SQL on that server?

I have created the similar scenario in my lab just now and checking......

mean while update me on my query

hi Soman
the path in  the snapshot is located in another server ..is the Backup Exec Server withot Sql Server installed ..
My question is :
can i restore the mdf database file in this location without the sql server ?This is not clear in the documentation ...

thanks !

you cannot restore the mdf and ldf file without a sql server .

you cannot restore the mdf and ldf file without a sql server .

You should have SQL installed on the server you are restoring the database because the backup is application aware backup.

ok
can i restore in same Sql Server in a new db with an another name ?

Yes

You can restore in the same SQL server with different DB name. For that I have already given the steps above with snaps.

Yes , that is possible

ok but the path can i setup must be in the Sql Server ? 
Or is not necessary because restore the db in an another db name ?

Yes the path must be in SQL server only not on any other server. You can restore it on any drive but that shold be local to the SQL server only.

Restoring DB to another name is up to you. In one instance you can create multiple databases. So you can define that DB name during the restoration.

i'm trying restore the db in the same sql server and this is the setup:

where :
e:\mssql.1 is a folder of Sql server where i want restore the DB

but receive this errore ..
Fare clic su un errore riportato di seguito per individuarlo nel registro processi
Ripristino-  V-79-65323-3154 -
Errore durante l'interrogazione del database Test.
V-79-65323-3154 - The backup set holds a backup of a database other than the existing 'Test' database.

any ideas ?
thanks

Hi Andrew

Please go through the site mention below

http://seer.entsupport.symantec.com/docs/246360.htm

Any Success??

Please update once done

hi

I followed http://seer.entsupport.symantec.com/docs/246360.htm but when try to make the inventory of the media ..the job stay in PAUSE ..and don't work ...
Why ??