Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Restore SQL Server 2005 Always Fail

Created: 03 Jul 2013 | 4 comments

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,

Operating Systems:

Comments 4 CommentsJump to latest comment

CraigV's picture

Hi Leo,

Check the TN below which details how to troubleshoot this issue:

http://www.symantec.com/business/support/index?pag...

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/r...

Thanks!

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...

Jaydeep S's picture

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)

LeoWidodo's picture

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.

Jaydeep S's picture

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.