"Richard K" <Richa***@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
>

"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" <Richa***@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
> >
>
>
>

"Richard K" <Richa***@discussions.microsoft.com> wrote in message
news:2264AE56-C465-4DDD-8FE6-546D2C14C30F@microsoft.com...
> 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" <Richa***@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
>> >
>>
>>
>>

"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" <Richa***@discussions.microsoft.com> wrote in message
> news:2264AE56-C465-4DDD-8FE6-546D2C14C30F@microsoft.com...
> > 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" <Richa***@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
> >> >
> >>
> >>
> >>
>
>
>