SQL Server 2014 Backup Maintenance Plans

This past weeks I have been helping a customer set up their SQL server backups. I have been reading a lot into this and I just realized how much there into it.

At the same time you also realize how critical is it to keep your database servers in a good condition by doing respective backups, making sure they are recoverable and cleaning up unnecessary files.

For the time being , the Maintenance Plans I ended setting up where :

  1. One plan to schedule a full backup of all databases,
  2. A second one to schedule differential backups every day (except the day of the full backup)
  3. A third one for the transactional logs, which can be set as often as you like.
  4. The fourth one is the cleaning, deletes files older than x weeks.

Be the first to comment

Leave a Reply

Your email address will not be published.


*