Need to schedule SQL backups
Posted on 2011-10-21
I do everything at my company so I'm not that familiar with this, but I need to schedule SQL backups of all our SQL servers. I need it to do a full backup one day and then differentials the next 2 days. Then do it again. But when it starts the third full backup set, to delete the oldest full backup and differentials. I want it to use SQL compression and it needs to go to a share via UNC path (\\backupserver\sqlbackups). Lastly I need it to email me if it fails, succeeds or there are any errors.
can anyone point me to a blog that shows exactly how to do this or cares to set up a script. I'm not too familar with SSMS, so if you suggest I do something there, please be specific where/how.
THis is on SQL Server 2008 R2 in Windows Server 2008 R2
Thanks so much!