5 Day Backup Maintenance Plan Help?

I am just getting used to SQL 2005 coming from SQL 2000 and can't figure
something out. In SQL 2000 I can go into the wizard and create a maintenance
plan to do a backup every night keeping 5 day's worth of (.bak) backup files,
each file having it's own naming convention using the date and time stamp as
part of the file name. Can't be any simpler. From there I backup each of
the .bak files to a tape.
When I go into the maintenance planner in the new SQL 2005 manager I can
create a backup plan but I can't seem to get it to create the same type of
thing. All it wants to do is overwrite the previous nights file, thus I only
have 1 file (most recent date) in my backup directory. What am I doing
wrong? Is there a simple Q article talking about this?
Thanks!
-Richard K
In the backup databases task you need to check the option for "Create a
Backup file for every database"
Andrew J. Kelly SQL MVP
"Richard K" <RichardK@.discussions.microsoft.com> wrote in message
news:F62187FE-7677-4408-8062-047B40D5EFC9@.microsoft.com...
>I am just getting used to SQL 2005 coming from SQL 2000 and can't figure
> something out. In SQL 2000 I can go into the wizard and create a
> maintenance
> plan to do a backup every night keeping 5 day's worth of (.bak) backup
> files,
> each file having it's own naming convention using the date and time stamp
> as
> part of the file name. Can't be any simpler. From there I backup each of
> the .bak files to a tape.
> When I go into the maintenance planner in the new SQL 2005 manager I can
> create a backup plan but I can't seem to get it to create the same type of
> thing. All it wants to do is overwrite the previous nights file, thus I
> only
> have 1 file (most recent date) in my backup directory. What am I doing
> wrong? Is there a simple Q article talking about this?
> Thanks!
> -Richard K
>
|||OK, got that part but no where in the wizard can I specify that I want to
hold 5 days worth of backups. That's what is confusing. Other than that I
like the new SQL Server Management Studio. I just have to get used to it.
"Andrew J. Kelly" wrote:

> In the backup databases task you need to check the option for "Create a
> Backup file for every database"
> --
> Andrew J. Kelly SQL MVP
> "Richard K" <RichardK@.discussions.microsoft.com> wrote in message
> news:F62187FE-7677-4408-8062-047B40D5EFC9@.microsoft.com...
>
>
|||Richard,
Pre SP2 you have to Modify the maintenance plan to add the Maintenance
Cleanup Task which will only delete down to Days.
SP2 CTP includes this Maintenance Cleanup Task in the wizard and allows the
delete to be in Hours.
Chris
"Richard K" <RichardK@.discussions.microsoft.com> wrote in message
news:2264AE56-C465-4DDD-8FE6-546D2C14C30F@.microsoft.com...[vbcol=seagreen]
> OK, got that part but no where in the wizard can I specify that I want to
> hold 5 days worth of backups. That's what is confusing. Other than that
> I
> like the new SQL Server Management Studio. I just have to get used to it.
> "Andrew J. Kelly" wrote:
|||OK, got it. I needed to add in a "cleanup task" to my routine. Very similar
to DTS package setup so very cool and flexible.
Thanks for the help Chris!!!
-Richard
"Chris Wood" wrote:

> Richard,
> Pre SP2 you have to Modify the maintenance plan to add the Maintenance
> Cleanup Task which will only delete down to Days.
> SP2 CTP includes this Maintenance Cleanup Task in the wizard and allows the
> delete to be in Hours.
> Chris
> "Richard K" <RichardK@.discussions.microsoft.com> wrote in message
> news:2264AE56-C465-4DDD-8FE6-546D2C14C30F@.microsoft.com...
>
>