07-03-2013 03:41 AM
Need Help.
I want to Restore SQL Server to different SQL Server, but always fail.
I am using Backup Exec 2010 to Backup SQL Server 2005 Service Pack 2.
My Backup Exec software installed in Windows Server 2008 R2 Enterprise.
I have some problems when i want to Restore Tape backup to Other SQL Server .
The error : The job failed with the following error: The directory is invalid.
When i see in SQL Server, the database name already create, but empty. No Table, views or anything.
I have follow the instruction from Symantec to Restore Database.
I think restore database could not be so difficult.
Is there anything certain condition to restore SQL Server to Different Server ?
For example Operating system that used for restore.
Thanks,
07-03-2013 03:48 AM
Hi Leo,
Check the TN below which details how to troubleshoot this issue:
http://www.symantec.com/business/support/index?page=content&id=TECH71493
You can also check the article below on how to redirect a SQL restore to make sure you're following the correct steps:
https://www-secure.symantec.com/connect/articles/restore-i-redirect-restore-sql-database-another-machine
Thanks!
07-03-2013 03:49 AM
OS is not really a problem unless it is Server 2012 and you dont have a beta patch applied on the agent. AS for the SQL Instance version, make sure that you are restoring to a SQL version which is same or higher.
As for the redirection, just follow the wizard with the default settings (for folder/path where to put the files) except, the Server, Instance and database name. I would also sugest you to try and restore the database with a different name (Make sure that the database does not exist)
07-03-2013 05:50 AM
Thanks for the Answer.
After i tries several configuration :
If I use Configuration => Use Alternate Drive => Always error Write data
If I Use Configuration => Use Destination Instance's Default data directory => Success
If I Use Configuration => Use this path (\\<computer ip address>\Folder) => error
What happen ?
What should i configure if i want to use => Use This path with network shared ?
Is it related to folder security ?
The folder SQLDTA and SQLLOG already created but empty.
07-03-2013 06:31 AM
You need to specify a local path on the server that you are restoring to.
Example: You are restoring to D:\databases on SQLServer then in the server field enter SQLServer, in instance field, either leave it blank if it is a default instance or the Instance name if the instance has a name. In thepath field, only enter D:\database.
Additionally, BE will restore the .mdf and .ldf file to the same folder and not 2 seperate folders. You would need to do this manually post restore by detaching and attaching the restored database.