For example,1. Are you using SPS Data Backup and Restore? ...vs. writing your own SQL Scripts?2. Are you using a multi-level strategy for server-level disaster recovery, site level backup&restore, document level backup&restore?
1. Most of our clients use SPS Data Backup/Restore for an initial restore. After this, we use either custom scripts or SQL Backup. The main issue with the built-in tool is that it doesn’t allow restoring to an existing portal and force you delete the portal first.2. Most of our clients use a Stand-by server where main production server is being restored automatically on a nightly basis, this allows them to access previous day or point of time backup to retrieve individual site and/or documents. We have written scripts to automate SQL restore from a production environment to a stand-by server.
he main issue with the built-in tool is that it doesn’t allow restoring to an existing portal and force you delete the portal first.Yes, this has caused us to stop using SPS Data B/R for server level B/R and resort our own custom SQL scripts along with iisback for the metabase and xcopy for c:\inetpub. We're working to incorporate stsadm for single site B/R and something like AvePoint for single document B/R.Re: We have written scripts to automate SQL restore from a production environment to a stand-by serverAre you use full backup/restores? ...or incremental? What is the size of your backups?
We use full backup, size is quite large 15Gb or more
We are using AvePoint DocAve for file/folder restore. It has workedwell so far and was easy to implement.Hint: the user this software runs under must have full rights on SQLserver and be an administrator on sharepoint box.