SqlServer 2005 Maintanence Plan Backup

17 Dec 2005 12:32 PM

Christian Haugan

In the maintanence plan wizard for SqlServer 2000 there was an option to
remove backupfiles older than x days. I cannot seem to find this option
in SqlServer2005. Is this option gone or simply moved/renamed?

regards,
Christian Haugan

17 Dec 2005 1:12 PM

Tibor Karaszi

In the plan designer (not the wizard), you have a task named "Maintenance Cleanup Take".

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quote

"Christian Haugan" <christ***@whrisky.com> wrote in message news:aBTof.2363$zc1.278@amstwist00...
> In the maintanence plan wizard for SqlServer 2000 there was an option to
> remove backupfiles older than x days. I cannot seem to find this option
> in SqlServer2005. Is this option gone or simply moved/renamed?
>
> regards,
> Christian Haugan

20 Dec 2005 5:26 AM

TomT

There is also a setting under Server properties, datbase settings, to set the
default backup media retention......

Show quote

"Christian Haugan" wrote:

> In the maintanence plan wizard for SqlServer 2000 there was an option to
> remove backupfiles older than x days. I cannot seem to find this option
> in SqlServer2005. Is this option gone or simply moved/renamed?
>
> regards,
> Christian Haugan
>

20 Dec 2005 6:49 PM

Tibor Karaszi

That setting will not provide for automatic overwrite or removal of old backup files. See the
documentation for explanation of the setting (sp_configure).

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quote

"TomT" <tomt@newsgroup.nospam> wrote in message
news:DF5D66BB-F0E8-422B-9FC4-4CB33E0C5992@microsoft.com...
> There is also a setting under Server properties, datbase settings, to set the
> default backup media retention......
>
> "Christian Haugan" wrote:
>
>> In the maintanence plan wizard for SqlServer 2000 there was an option to
>> remove backupfiles older than x days. I cannot seem to find this option
>> in SqlServer2005. Is this option gone or simply moved/renamed?
>>
>> regards,
>> Christian Haugan
>>