<div>
I did that - and it does not work....the files are still there over one week old....<br />
<br />
I setup Maintenance plan to clean up backup files from SQL 2005 server, but I found out every time I run the job (maintenance plan)- whether automatic or manual, the .bak files are still in the folders. &nbsp;Any help or suggestion will be greatly appreciated?<br />
<br />
P.S. I set it up to delete all files older than 1 week.
</div>


I did that - and it does not work....the files are still there over one week old....

I setup Maintenance plan to clean up backup files from SQL 2005 server, but I found out every time I run the job (maintenance plan)- whether automatic or manual, the .bak files are still in the folders.  Any help or suggestion will be greatly appreciated?

P.S. I set it up to delete all files older than 1 week.

<div>
I can only assume that you've put the backups in a place that's different from where the Maint Plan is looking.<br />
<br />
... double check the paths
</div>


I can only assume that you've put the backups in a place that's different from where the Maint Plan is looking.

... double check the paths

<div>
no - they are pointing to the correct location.....but someone just shared with me that the file extension needs to only say &quot;bak&quot; and nothing else, no &quot;.bak&quot; no &quot;*.bak&quot; etx..... I had *.bak so I am going to test that and see what happens....thanks for responding btw.
</div>


no - they are pointing to the correct location.....but someone just shared with me that the file extension needs to only say "bak" and nothing else, no ".bak" no "*.bak" etx..... I had *.bak so I am going to test that and see what happens....thanks for responding btw.

<div>
<div class="content wysiwyg-content">
Hi.<br />
<br />
I'm new to MS SQL 2005 and would like to create a maintenance plan to delete old backup files. Please assist me wit the steps.<br />
<br />
Thanks
</div>
</div>


Hi.

I'm new to MS SQL 2005 and would like to create a maintenance plan to delete old backup files. Please assist me wit the steps.

Thanks

Create a successfull maintenance plan to delete old backups

A router is a networking device that forwards data packets between computer networks. Routers perform the "traffic directing" functions on the Internet. The most familiar type of routers are home and small office cable or DSL routers that simply pass data, such as web pages, email, IM, and videos between computers and the Internet. More sophisticated routers, such as enterprise routers, connect large business or ISP networks up to the powerful core routers that forward data at high speed along the optical fiber lines of the Internet backbone. Though routers are typically dedicated hardware devices, use of software-based routers has grown increasingly common.

Routers

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.