Problem restoring Sharepoint services 3.0 subsite using Backup Exec 12 and Sharepoint agent

One of our clients has mistakenly deleted a Sharepoint Service 3.0 subsite.  They have Backup Exec 12 which is using the Sharepoint agent to backup the site collection.

I tried restoring the subsite by selecting it in the server farm part of the selection list, checked the Sharepoint specific restore settings and ran the restore job.  Each time I attempt the restore job it completes with 100% successful and claims to have restored 2.8GB of data but when I try and access the subsite I get a 404 error and the subsite isn't listed in the site settings, so it doesn't look like it has been restored.

I have had a good search through Symantec's knowledge base, but can't figure out what is going wrong.

Thanks for reading this question.
LVL 1
dylanarcherAsked:
Who is Participating?
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.

WadskiIT DirectorCommented:
Are you doing this:

Stop the sharepoint services
Restore
Start Sharepoint services


http://support.microsoft.com/kb/943605
0
Andrei TeodorescuBusiness OwnerCommented:
You can not restore a subsite (web), but an entire site-collection.
0
Andrei TeodorescuBusiness OwnerCommented:
... unless you're making use of STSADM commands import/export
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

dylanarcherAuthor Commented:
Wadski, thanks, I will give that a try.

Andrei, Symantec's documentation for Backup Exec 12 says that it can restore individual sites, document lists, documents, etc.. which I thought was the whole point.  I know that it the agent could only restore a whole site collection in 10d.

If there is no other answer I plan to restore the whole site collection to a different server and use stsadm to export the subsite and then import it to the live one.
0
GreatGermCommented:
BE12 will most definitely allow for granular restore (down to a single item) if the backup was properly setup for it.  I know you said that you selected the SharePoint specific restore options, but some of those aren't for 3.0 and can cause issues. Please verify what you selected compared to the recommendations in this document: http://seer.entsupport.symantec.com/docs/310403.htm

You can also treat this as a redirected backup and see if you can restore directly to the location.
0
dylanarcherAuthor Commented:
Thanks GreatGerm.

Restoring the subsite to the live site collection using Backup Exec didn't work, I tried it many times.  It would say completed 100% successful but the subsite wasn't there.  I tried exporting the whole site collection and reimporting it (saw this solution somewhere) and that didn't work either.

The solution was to install Sharepoint on another server, patch it to the same level as the live server.  Create a new web application and site collection, then I restored the whole site collection to this new location using Sharepoint redirection.

With the content of the deleted subsite now available I used stsadm to export the content.  I created a new subsite with the same name as before in the live site collection and then imported the data using stsadm.

A couple of things that stumped me along the way...

-  I had repeated 'Access Denied' errors trying to do the restore.  It turned out that this was happening because I had a following '\' in the sharepoint redirection url.
-  stsadm import failed with unable to find 'requirements.xml' this was because I specified the extension of the export backup file when i ran the export
0

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
GreatGermCommented:
You shouldn't have needed to do that while running BE12.  Also, if you have to do a major recovery again in the future and the standard BE12 restore isn't working, you should be able to just use a new web app to restore the site collection to rather than having to install and patch a new server.
0
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.