|
Home > Archive > MS SQL Server Tools > December 2006 > SS2005 Management Studio question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SS2005 Management Studio question
|
|
| Peter Lux 2006-12-13, 7:13 pm |
| I've got our production Great Plains db's on SqlServer 2005. In management
studio, I've defined my maintenance tasks to backup the db's (34 - each
company is a separate database) into separate subdirectories. The backup is
fine, but deleting the older backups (2 days) is difficult. In the
"maintenance" task, it only specifies one directory that you can delete
from.
Someone told me that SP1 fixes this, but I didn't see it in any of the
fixes, but I might not be looking at the right spot.
| |
| Tibor Karaszi 2006-12-13, 7:13 pm |
| sp1 has an option (checkbox) to traverse first-level subdirectories in the clean-up task.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"Peter Lux" <pete.lux@theheritagegrp.com> wrote in message
news:OfvLg4uHHHA.3676@TK2MSFTNGP03.phx.gbl...
> I've got our production Great Plains db's on SqlServer 2005. In management studio, I've defined my
> maintenance tasks to backup the db's (34 - each company is a separate database) into separate
> subdirectories. The backup is fine, but deleting the older backups (2 days) is difficult. In the
> "maintenance" task, it only specifies one directory that you can delete from.
>
> Someone told me that SP1 fixes this, but I didn't see it in any of the fixes, but I might not be
> looking at the right spot.
>
| |
| Charles Wang[MSFT] 2006-12-14, 12:14 am |
| Yes, SQL Server 2005 SP1 provides an option "Include first-level
subfolders" in "Maintenance Cleanup Task".
Thanks for using Microsoft Managed Newsgroup. If you have any other
questions or concerns, please feel free to let us know.
Charles Wang
Microsoft Online Community Support
====================
====================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
====================
====================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
====================
====================
==============
|
|
|
|
|