Solved

SQL 2012 backup job

Posted on 2014-03-21
1
754 Views
Last Modified: 2014-03-21
Hi all,

Im not a DBA but I have to backup all out databases. I have setup a maintenance job that takes a full backup of our databases every night. I have ticked the box that says "backup set will expire" after 7 days, but it keeps filling up the disk. Am I missing something?
BUbackup2.JPG
0
Comment
Question by:Matt
1 Comment
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 500 total points
ID: 39944865
The "Backup set will expire" option only indicates after how long a backup set can be overwritten, it doesn't actually remove the old backups from disk.

You will need to add a separate "Maintenance Cleanup Task" to do that: http://msdn.microsoft.com/en-us/library/ms177182.aspx
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how the fundamental information of how to create a table.

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question