|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
sql2005 maintenance plan for tlogHi: In 2000 EM I was able to create a single maintenance plan that would
back up the dB on a specific schedule and back up the tlog on a different schedule, and automatically delete backups past a certain date. Is that still possible to do? or do I have to create a separate maintenance plan for the dB backup and tlog backup? I tried to create a separate tlog backup using the wizard, but I couldn't figure out how to delete older tlog backups...is that still possible or do I need to manually remove older tlog backups? You will need two plans if you want to use different schedules. There is a
task in the wizard for deleting old backup files. -- Show quoteAndrew J. Kelly SQL MVP "geek-y-guy" <no***@nowhere.org> wrote in message news:uOLgGyK5GHA.668@TK2MSFTNGP02.phx.gbl... > Hi: In 2000 EM I was able to create a single maintenance plan that would > back up the dB on a specific schedule and back up the tlog on a different > schedule, and automatically delete backups past a certain date. > > Is that still possible to do? or do I have to create a separate > maintenance plan for the dB backup and tlog backup? > > I tried to create a separate tlog backup using the wizard, but I couldn't > figure out how to delete older tlog backups...is that still possible or do > I need to manually remove older tlog backups? > The wizard doesn't have the remove old backup file task, for some strange reason (unless I've missed
it, but I'm pretty certain). You have to open the plan in the designer to get to that task type. -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message news:e%23xOLIQ5GHA.1196@TK2MSFTNGP02.phx.gbl... > You will need two plans if you want to use different schedules. There is a task in the wizard for > deleting old backup files. > > -- > Andrew J. Kelly SQL MVP > > "geek-y-guy" <no***@nowhere.org> wrote in message news:uOLgGyK5GHA.668@TK2MSFTNGP02.phx.gbl... >> Hi: In 2000 EM I was able to create a single maintenance plan that would back up the dB on a >> specific schedule and back up the tlog on a different schedule, and automatically delete backups >> past a certain date. >> >> Is that still possible to do? or do I have to create a separate maintenance plan for the dB >> backup and tlog backup? >> >> I tried to create a separate tlog backup using the wizard, but I couldn't figure out how to >> delete older tlog backups...is that still possible or do I need to manually remove older tlog >> backups? >> > > You may be right, but it is definitely there in the designer. And with SP1
you can delete from subdirs unlike RTM which does not. -- Show quoteAndrew J. Kelly SQL MVP "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message news:OjR3A4R5GHA.3444@TK2MSFTNGP02.phx.gbl... > The wizard doesn't have the remove old backup file task, for some strange > reason (unless I've missed it, but I'm pretty certain). You have to open > the plan in the designer to get to that task type. > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://www.solidqualitylearning.com/ > > > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message > news:e%23xOLIQ5GHA.1196@TK2MSFTNGP02.phx.gbl... >> You will need two plans if you want to use different schedules. There is >> a task in the wizard for deleting old backup files. >> >> -- >> Andrew J. Kelly SQL MVP >> >> "geek-y-guy" <no***@nowhere.org> wrote in message >> news:uOLgGyK5GHA.668@TK2MSFTNGP02.phx.gbl... >>> Hi: In 2000 EM I was able to create a single maintenance plan that would >>> back up the dB on a specific schedule and back up the tlog on a >>> different schedule, and automatically delete backups past a certain >>> date. >>> >>> Is that still possible to do? or do I have to create a separate >>> maintenance plan for the dB backup and tlog backup? >>> >>> I tried to create a separate tlog backup using the wizard, but I >>> couldn't figure out how to delete older tlog backups...is that still >>> possible or do I need to manually remove older tlog backups? >>> >> >> > > You may be right, but it is definitely there in the designer. Yep, this is one of the things I make sure to show my students. Otherwise, some will end up with full disks over time. :-) -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message news:Og8m2mW5GHA.2264@TK2MSFTNGP02.phx.gbl... > You may be right, but it is definitely there in the designer. And with SP1 you can delete from > subdirs unlike RTM which does not. > > -- > Andrew J. Kelly SQL MVP > > "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message > news:OjR3A4R5GHA.3444@TK2MSFTNGP02.phx.gbl... >> The wizard doesn't have the remove old backup file task, for some strange reason (unless I've >> missed it, but I'm pretty certain). You have to open the plan in the designer to get to that task >> type. >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://www.solidqualitylearning.com/ >> >> >> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message >> news:e%23xOLIQ5GHA.1196@TK2MSFTNGP02.phx.gbl... >>> You will need two plans if you want to use different schedules. There is a task in the wizard >>> for deleting old backup files. >>> >>> -- >>> Andrew J. Kelly SQL MVP >>> >>> "geek-y-guy" <no***@nowhere.org> wrote in message news:uOLgGyK5GHA.668@TK2MSFTNGP02.phx.gbl... >>>> Hi: In 2000 EM I was able to create a single maintenance plan that would back up the dB on a >>>> specific schedule and back up the tlog on a different schedule, and automatically delete >>>> backups past a certain date. >>>> >>>> Is that still possible to do? or do I have to create a separate maintenance plan for the dB >>>> backup and tlog backup? >>>> >>>> I tried to create a separate tlog backup using the wizard, but I couldn't figure out how to >>>> delete older tlog backups...is that still possible or do I need to manually remove older tlog >>>> backups? >>>> >>> >>> >> > > thanks for all the feedback.
I stumbled on the remove backups task after creating a maintenance schedule, but wondered if I was somehow missing it in the wizard. Show quote "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message news:%23PQ3WVX5GHA.1196@TK2MSFTNGP02.phx.gbl... >> You may be right, but it is definitely there in the designer. > > Yep, this is one of the things I make sure to show my students. Otherwise, > some will end up with full disks over time. :-) > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://www.solidqualitylearning.com/ > > > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message > news:Og8m2mW5GHA.2264@TK2MSFTNGP02.phx.gbl... >> You may be right, but it is definitely there in the designer. And with >> SP1 you can delete from subdirs unlike RTM which does not. >> >> -- >> Andrew J. Kelly SQL MVP >> >> "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote >> in message news:OjR3A4R5GHA.3444@TK2MSFTNGP02.phx.gbl... >>> The wizard doesn't have the remove old backup file task, for some >>> strange reason (unless I've missed it, but I'm pretty certain). You have >>> to open the plan in the designer to get to that task type. >>> >>> -- >>> Tibor Karaszi, SQL Server MVP >>> http://www.karaszi.com/sqlserver/default.asp >>> http://www.solidqualitylearning.com/ >>> >>> >>> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message >>> news:e%23xOLIQ5GHA.1196@TK2MSFTNGP02.phx.gbl... >>>> You will need two plans if you want to use different schedules. There >>>> is a task in the wizard for deleting old backup files. >>>> >>>> -- >>>> Andrew J. Kelly SQL MVP >>>> >>>> "geek-y-guy" <no***@nowhere.org> wrote in message >>>> news:uOLgGyK5GHA.668@TK2MSFTNGP02.phx.gbl... >>>>> Hi: In 2000 EM I was able to create a single maintenance plan that >>>>> would back up the dB on a specific schedule and back up the tlog on a >>>>> different schedule, and automatically delete backups past a certain >>>>> date. >>>>> >>>>> Is that still possible to do? or do I have to create a separate >>>>> maintenance plan for the dB backup and tlog backup? >>>>> >>>>> I tried to create a separate tlog backup using the wizard, but I >>>>> couldn't figure out how to delete older tlog backups...is that still >>>>> possible or do I need to manually remove older tlog backups? >>>>> >>>> >>>> >>> >> >> >  |
|||||||||||||||||||||||
Other interesting topics