SoZo Hosting 800-640-4892: Specializing In Windows Dedicated Server, Linux Dedicated Server, ColdFusion Dedicated Server, ColdFusion Hosting, Cloud Hosting, Windows Hosting, Linux Hosting, SEO, Web Full Page Ads...

MS SQL 2008 and MS SQL 2012 Backup Maintenance Plans on Windows Server 2008R and Windows Server 2012R2 operating systems.

1) Make sure you turn on MS SQL Agent in Windows Services and start it and set the properties to automatic as if you don’t, a reboot of the server can stop MS SQL Agent which will stop your MS SQL database backups on these Maintenance plans

2) Open up the Microsoft SQL Server Management Studio on your server and on the left click on the Management menu then Maintenance Plan submenu

3) Right click and choose the: Maintenance Plan Wizard

4) Click Next and Add a name and Description such as MS SQL 2008 Backups or MS SQL 2012 Backups

5) On the bottom of that screen click on the CHANGE button under the schedule section and set the backup times such as Daily at some off prime time setting like midnight. Click Next

6) Select the BACK UP DATABASE (FULL) option checkbox and click Next and Next

7) You can backup 1 database or a set of databases or ALL databases. We recommend selecting ALL databases which means new databases added in the future will be backed up. On that same screen click on the CREATE A BACKUP FILE FOR EVERY DATABASE option, check the check box for creating a SUBFOLDER FOR EACH DATABASE and click on the browse option to find a folder on another drive for your back-ups. Keep the bak as the backup file extension name as that is standard. You don’t want your backups to be on the same drive as your MS SQL Server installation. Backups to another server are best but you might have the whole server being backed up by a tool like r1soft to another server anyway so backup to a different hard drive is fine. You want to check the VERIFY BACKUP INTEGRITY check box. Click next

8) Write the backup results file to the same folder in step 7. Click next to finish it and you are done. The backups will start at the interval you set in step 5

 

 

MS SQL 2008 and MS SQL 2012 Backup Deletion Maintenance Plans on Windows Server 2008R and Windows Server 2012R2 operating systems

1) This section assumes you have a MS SQL 2008 and 20012 Backup Maintenance in place. You cannot delete MS SQL backups you don’t have so see the above section for creating MS SQL backups.

2) Make sure you turn on MS SQL Agent in Windows Services and start it and set the properties to automatic as if you don’t, a reboot of the server can stop MS SQL Agent which will stop your MS SQL database backup deletions on these Maintenance plans

3) Open up the Microsoft SQL Server Management Studio on your server and on the left click on the Management menu then Maintenance Plan submenu

4) Right click and choose the: Maintenance Plan Wizard

5) Click Next and Add a name and Description such as DELETE MS SQL 2008 Backups AFTER 14 Days or DELETE MS SQL 2012 Backups AFTER 28 Days

6) On the bottom of that screen click on the CHANGE button under the schedule section and set the backup times such as Daily at a time about an hour or so later than the time you do backups (See above MS SQL Back Ups Section step 5) so let’s say 12:55AM in this case. Click Next

7) Select the MAINTENANCE CLEANUP TASK option checkbox and click Next and Next

8) Click on the SEARCH FOLDER AND DELETE FILES BASED ON AN EXTENSION option, click on the folder button and find the location of your back-ups (see step 7 in the above MS SQL Back Ups Section) After selecting where the backup files are, enter bak in the FILE EXTENSION text box and check the INCLUDE FIRST-LEVEL subfolders check box. Change the File age to something like 14 days or 28 days and make sure the DELETE FILES BASED ON THE AGE OF THE FILE AT TASK RUN TIME check box is checked. Click next.

9) Write the backup results file to the same folder in step 8. Click next to finish it and you are done. The backup deletions will start at the interval you set in steps 5 and 8