04-27-2012 07:27 AM
Hi,
I need to restore MSSQL db file to alternate location. Not to MSSQL instance, there should I look?
Destination / Microsoft SQL Redirection / Destination Options?
thank you
04-27-2012 07:37 AM
You will have to restore the SQL DB to another instance of SQL. The options for this are under Microsoft SQL Redirection.
04-27-2012 07:46 AM
Do you meen that I can not restore sql DB just to simple file ?
thanks
04-27-2012 07:50 AM
That is correct. Backup Exec doesn't actually backup the DB files for a database during the backup, it dumps the contents of the database to the backup container, as per the Microsoft guide lines using SQLVDI for backups. So because of this we can't just restore the files.
The restore has to go to another SQL instance or the same instance but a different database name. During the restore it will create new DB files on the target server and the data will be dumped back into that.
04-27-2012 08:14 AM
thank you very much