﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration  / Maintenance Plan for Daily backup for a specific Database Not working as expected / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Fri, 24 May 2013 05:32:59 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: Maintenance Plan for Daily backup for a specific Database Not working as expected</title><link>http://www.sqlservercentral.com/Forums/Topic1409449-1550-1.aspx</link><description>what is happening?  are you seeing files older than 4 days still there?</description><pubDate>Mon, 21 Jan 2013 05:08:26 GMT</pubDate><dc:creator>anthony.green</dc:creator></item><item><title>RE: Maintenance Plan for Daily backup for a specific Database Not working as expected</title><link>http://www.sqlservercentral.com/Forums/Topic1409449-1550-1.aspx</link><description>Okay, can I suggest you run process monitor to see what the clean up task is actually doing?</description><pubDate>Mon, 21 Jan 2013 03:26:14 GMT</pubDate><dc:creator>Abu Dina</dc:creator></item><item><title>RE: Maintenance Plan for Daily backup for a specific Database Not working as expected</title><link>http://www.sqlservercentral.com/Forums/Topic1409449-1550-1.aspx</link><description>actually there was no dot... its just 'BAK' I should not have typed dot while i was replying to you.</description><pubDate>Mon, 21 Jan 2013 03:23:34 GMT</pubDate><dc:creator>Mac1986</dc:creator></item><item><title>RE: Maintenance Plan for Daily backup for a specific Database Not working as expected</title><link>http://www.sqlservercentral.com/Forums/Topic1409449-1550-1.aspx</link><description>Remove the dot. So instead of [b].bak[/b] just put [b]bak[/b]</description><pubDate>Mon, 21 Jan 2013 03:17:33 GMT</pubDate><dc:creator>Abu Dina</dc:creator></item><item><title>RE: Maintenance Plan for Daily backup for a specific Database Not working as expected</title><link>http://www.sqlservercentral.com/Forums/Topic1409449-1550-1.aspx</link><description>Yes I did. '.BAK'. Is it case sensitive? should I mention '.bak' instead?</description><pubDate>Mon, 21 Jan 2013 03:16:12 GMT</pubDate><dc:creator>Mac1986</dc:creator></item><item><title>RE: Maintenance Plan for Daily backup for a specific Database Not working as expected</title><link>http://www.sqlservercentral.com/Forums/Topic1409449-1550-1.aspx</link><description>Have you specified a file extension in your Maintenance Cleanup Task?</description><pubDate>Mon, 21 Jan 2013 03:07:13 GMT</pubDate><dc:creator>Abu Dina</dc:creator></item><item><title>Maintenance Plan for Daily backup for a specific Database Not working as expected</title><link>http://www.sqlservercentral.com/Forums/Topic1409449-1550-1.aspx</link><description>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.</description><pubDate>Mon, 21 Jan 2013 02:57:39 GMT</pubDate><dc:creator>Mac1986</dc:creator></item></channel></rss>