Sharepoint 2007 - backup scripts versus SQL backups
Posted on 2014-02-20
I'm currently using the SharePoint scripts to backup my SharePoint 2007 instance. It backs up the web folders and the DBs in one scripts/process.. It also makes the restore much easier.. The only problem is that the SharePoint backup VBS scripts do not email the status of the backup everyday. I have to check the folder manually everyday and look at the log file... Also.. I have to make it run FULL everyday for I'm also backing up the SQL DBs and the DIFF SharePoint jobs won't run due to another SQL job doing LOG backups on the weekdays. But.. If I backup via SQL I get a daily backup report emailed to me. But... As I understand I have to backup the web folders right before or after the SQL backups, correct? So.. If I go the SQL backup route and simply backup the web folders will I be okay? What exact folders do I need to backup?
Or.. Should I just have the SharePoint scripts run FULL on a few days of the week and have SQL backup 7 days a week. That way if something happens I simply restore the most recent SharePoint backup and then do a restore of SQL. Would I jsut remove the days in the script like below? I guess I could run FULLs on everyday but the drive is kinna' small.
Question.. What if I want to only run Fulls on a few days of the week? For example. Have Monday, Wed, and Friday run FULLS and the other days don't run. Is there a NONE or SKIP command? Or would I simply remove the days like below?
select case Weekday(BackupDate)
'Please change your schedule here if necessary