Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

SQL redirect restore job fails

Created: 01 Jul 2009 • Updated: 21 May 2010 | 25 comments

hi
i'm trying to do a Sql redirect restore in a specific folder in the Backup Exec Server of one database but receive this messagge error :
V-79-65323-5105 - A file activation error occurred. The physical file name '\Dati\MSSQL.1\MSSQL\Data\db.mdf' may be incorrect. Diagnose and correct additional errors, and retry the operation.

The physical file name of folder is correct !
i tried read this article http://seer.entsupport.symantec.com/docs/321725.htm but i dont' resolve the problem ..

thanks !!

Comments 25 CommentsJump to latest comment

Abhijit Soman's picture

How are you redirecting the SQL databas restoration?

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

Please check and confirm. If this remedy worked for you Kindly mark it as a SOLUTION

Regards, Abhijit
Carlos - Dept. Informatica's picture

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

Abhijit Soman's picture

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.

imagebrowser image

Please check and confirm. If this remedy worked for you Kindly mark it as a SOLUTION

Regards, Abhijit
Andrew Soc's picture

thanks Soman
but i don't want restore the database DB1 overwriting the existing database, but i want restore in an other location for restore some table ecc...
I've got only one database Server , can create a new database with a different name ..for example db2 and restore the db1 backup on db2 ?
Which path i must write ? The same of db1 ?

thanks!!!!

Ben L.'s picture

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

If this response answers your concern, please mark it as a "solution"

mvg's picture

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"

Andrew Soc's picture

attach the screenshot

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

imagebrowser image

Abhijit Soman's picture

Please check by defining Server name & Database name

I think it will be required...

Please confirm

Please check and confirm. If this remedy worked for you Kindly mark it as a SOLUTION

Regards, Abhijit
Andrew Soc's picture

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

Abhijit Soman's picture

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

Please check and confirm. If this remedy worked for you Kindly mark it as a SOLUTION

Regards, Abhijit
Andrew Soc's picture

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 !

RahulG's picture

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

RahulG's picture

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

Abhijit Soman's picture

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

Please check and confirm. If this remedy worked for you Kindly mark it as a SOLUTION

Regards, Abhijit
Andrew Soc's picture

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

Abhijit Soman's picture

Yes

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

Please check and confirm. If this remedy worked for you Kindly mark it as a SOLUTION

Regards, Abhijit
Symboy's picture

Yes , that is possible

Note: If this post provides you with a solution don't forget to mark the discussion as solved.

Andrew Soc's picture

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 ?

Abhijit Soman's picture

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.

Please check and confirm. If this remedy worked for you Kindly mark it as a SOLUTION

Regards, Abhijit
Andrew Soc's picture

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

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.

Abhijit Soman's picture

Hi Andrew

Please go through the site mention below

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

Please check and confirm. If this remedy worked for you Kindly mark it as a SOLUTION

Regards, Abhijit
Abhijit Soman's picture

Any Success??

Please update once done

Please check and confirm. If this remedy worked for you Kindly mark it as a SOLUTION

Regards, Abhijit
Andrew Soc's picture

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

Andrew Soc's picture

update

i followed http://seer.entsupport.symantec.com/docs/246360.htm and after i have try to restore the db but receive the same error
V-79-65323-3154 - The backup set holds a backup of a database other than the existing 'Test' database.