Maintenance Plan for Daily backup for a specific Database Not working as expected

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Maintenance Plan for Daily backup for a...

Maintenance Plan for Daily backup for a specific Database Not working as expected

Rate Topic

Display Mode

Topic Options

Author

Message

Mac1986

Posted Monday, January 21, 2013 2:57 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:33 AM
Points: 180, Visits: 512

Hi All,
i have created a Maintenance Plan for daily FULL Backup of 2 databases in a SQL Instance. The Job is taking backup file successfully but not cleaning up the old files. So my Disk is getting filled up with old backup files.

I have included 'Maintenance Cleanup task' in the Plan and the retention period to 2 days. Meaning we do not need any backup files prior to 2 days. Not sure why this is not able to clear the old backup copies.

The intresting thing is, I created a similar Plan on various SQL Instances and but selected default all databases option in the 'Backup Database task'. And it works like a charm.

Can you please suggest what is missing here. and please let me know if you need any information to figure out the bottle neck.

Post #1409449

Abu Dina

Posted Monday, January 21, 2013 3:07 AM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 9:23 AM
Points: 484, Visits: 2,126

Have you specified a file extension in your Maintenance Cleanup Task?

-----------------------------------
http://www.SQL4n00bs.com

Post #1409452

Mac1986

Posted Monday, January 21, 2013 3:16 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:33 AM
Points: 180, Visits: 512

Yes I did. '.BAK'. Is it case sensitive? should I mention '.bak' instead?

Post #1409454

Abu Dina

Posted Monday, January 21, 2013 3:17 AM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 9:23 AM
Points: 484, Visits: 2,126

Remove the dot. So instead of .bak just put bak

-----------------------------------
http://www.SQL4n00bs.com

Post #1409455

Mac1986

Posted Monday, January 21, 2013 3:23 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:33 AM
Points: 180, Visits: 512

actually there was no dot... its just 'BAK' I should not have typed dot while i was replying to you.

Post #1409457

Abu Dina

Posted Monday, January 21, 2013 3:26 AM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 9:23 AM
Points: 484, Visits: 2,126

Okay, can I suggest you run process monitor to see what the clean up task is actually doing?

-----------------------------------
http://www.SQL4n00bs.com

Post #1409459

anthony.green

Posted Monday, January 21, 2013 5:08 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

what is happening? are you seeing files older than 4 days still there?

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1409493

« Prev Topic | Next Topic »

Permissions