Hi all, this is my first time posting here in the Symantec forums, so I will do my best.
I just recently went through the setup of SharePoint (wss 3.0) for backing up the database components, and thought I would share my experience.
First off, Backup Exec 11d, with the latest updates, will now support SharePoint 2007, wss 3.0, and wss 2.0 (pending you have the SharePoint agent added into backup exec - as well as the server agent installed on the actual SharePoint server). In my case, the database for SharePoint resides on an SQL box, running SQL 2000 with the latest service pack for SQL, therefore I needed to have the server agent installed on the SQL server as well. Turns out, the administrator account used on the SharePoint server (within SharePoint you can set the administrator of SharePoint) needs to have "Sys Admin" rights on the SQL server, where the database resides. Needless to say, our BSG group wasn't too happy about that, but none-the-less that is what needs to be done. Then within Backup Exec, I changed the "Resource Credentials" on the job set up to use that account (basically telling the agent which login credentials to use).
When setting up the job, I had to manually add the SharePoint server under "Microsoft SharePoint Server Farms" by right-clicking and selecting "Add Server Farm..." Once added, I checked the box so that it selected all resources to be backed up.
Once the job runs and completes, you will have the option under "Restore" to select individual files. If you want to re-direct a file(s) you must select "Microsoft SharePoint Redirection" and select "Redirect SharePoint documents sets" and you can then select where you want to direct the file(s). I tried using the basic "File Redirection" option, but after some testing that did not seem to work.
At any rate, I hope this helps anyone out there. I will subscribe to this post, so if anyone has any questions just let me know and I will try to help as best I can, thanks!
Nathan
