Restore SharePoint Using Backup Exec 12.5

Hi There

we currently have a production and test SharePoint Farm setup. We are running backup exec 12.5 with the SharePoint Agent on both Farms. My topology is the same in both environments:

1 x SQL 2005 box
1 x SharePoint 2007 Server - WFE.

I am wanting to restore a site collection from from Farm A to Farm B and am not exactly sure of the process I have confirmed that the backups are successful.
This is what I have tried:
> Create a restore job
> Under selections I choose the web application and cyle to the latest backup which holds the  content database
> I go to the SharePoint Redirection setting and I type in the URL for the destination and the Front-end server name

When I initiate this it fails. Is this the correct procedure or is there something missing?

I know I can restore the whole content database using the SQL Redirection but I believe this is not the correct procedure as there are alot of unique identifiers which are carried across which need to be reset.
I can do this process using the STSADM backup - restore commands but I would like to use backupexec

Any help would be much appreciated.

Cheers Nathan

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ted BouskillSenior Software DeveloperCommented:
Sharepoint isn't cloneable.  The databases and servers are tightly coupled.  You can move non configuration databases between SQL instances or to new drives but they have to be part of the same configuration.

Cloning Sharepoint is the same as a disaster recovery.  You setup Sharepoint and use a combination of stsadm and SQL to restore the non-Administration content databases.  Search this site and the web for articles on 'disaster recovery' and Sharepoint
DAHelpAuthor Commented:
I am aware of this and have moved content databases between SQL instances in the past using the stsadm -preparetomove command than moving the databases across.

My question is how does Backup Exec handle this? Is there anyway of restoring a content database from one farm to another just using backup exec? I know there is site ID's etc kept in the content databases which need to be reset when moving the database this is why the preparetomove command is initiated.

Ted BouskillSenior Software DeveloperCommented:
No there isn't.  You have to use stsadm as part of the process.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage Software

From novice to tech pro — start learning today.