|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Maintenance Plan on SQL2005I setup a maintenance plan using the Wizard but it doesn't allow me to
choose any databases to backup other than the default ones (master, model, msdb, tempdb). Please advise. Thanks, Ademar. Check the database compatibility level. The Wizard doesn't show databases in
70 compatibility level. -- Show quoteRick Byham MCDBA, MCSE, MCSA Documentation Manager, Microsoft, SQL Server Books Online This posting is provided "as is" with no warranties, and confers no rights. "Ademar" <ademar@nospam.com> wrote in message news:%23euw$AYbGHA.4900@TK2MSFTNGP02.phx.gbl... >I setup a maintenance plan using the Wizard but it doesn't allow me to >choose any databases to backup other than the default ones (master, model, >msdb, tempdb). > > Please advise. > > Thanks, > Ademar. > Yes, it is in 70.
Thanks! Show quote "Rick Byham [MS]" <rick***@online.microsoft.com> wrote in message news:u$qfHGgbGHA.4900@TK2MSFTNGP02.phx.gbl... > Check the database compatibility level. The Wizard doesn't show databases > in 70 compatibility level. > -- > Rick Byham > MCDBA, MCSE, MCSA > Documentation Manager, > Microsoft, SQL Server Books Online > This posting is provided "as is" with > no warranties, and confers no rights. > > "Ademar" <ademar@nospam.com> wrote in message > news:%23euw$AYbGHA.4900@TK2MSFTNGP02.phx.gbl... >>I setup a maintenance plan using the Wizard but it doesn't allow me to >>choose any databases to backup other than the default ones (master, model, >>msdb, tempdb). >> >> Please advise. >> >> Thanks, >> Ademar. >> > > When using the Wizard, I can choose the following options:
Reorganize Index Rebuild Index Update Statistics What is the difference between the two? Aren't they all the same? Thanks. Show quote "Ademar" <ademar@nospam.com> wrote in message news:%23euw$AYbGHA.4900@TK2MSFTNGP02.phx.gbl... >I setup a maintenance plan using the Wizard but it doesn't allow me to >choose any databases to backup other than the default ones (master, model, >msdb, tempdb). > > Please advise. > > Thanks, > Ademar. > Never mind this question. I got the answer I needed.
Thanks. Show quote "Ademar" <ademar@nospam.com> wrote in message news:exSi8NtbGHA.4900@TK2MSFTNGP02.phx.gbl... > When using the Wizard, I can choose the following options: > > Reorganize Index > Rebuild Index > Update Statistics > > What is the difference between the two? Aren't they all the same? > > Thanks. > > "Ademar" <ademar@nospam.com> wrote in message > news:%23euw$AYbGHA.4900@TK2MSFTNGP02.phx.gbl... >>I setup a maintenance plan using the Wizard but it doesn't allow me to >>choose any databases to backup other than the default ones (master, model, >>msdb, tempdb). >> >> Please advise. >> >> Thanks, >> Ademar. >> > > Where in the maintenance plan to I specify the number of days or weeks to
keep backups? Doesn't look like it's the "Clean up History" option. Thanks, Ademar. Show quote "Ademar" <ademar@nospam.com> wrote in message news:%23euw$AYbGHA.4900@TK2MSFTNGP02.phx.gbl... >I setup a maintenance plan using the Wizard but it doesn't allow me to >choose any databases to backup other than the default ones (master, model, >msdb, tempdb). > > Please advise. > > Thanks, > Ademar. > Modify the maintenance plan and add a Maintenance Cleanup
Task. This task allows you to define the conditions you want to use to delete older backups. -Sue On Wed, 3 May 2006 15:45:32 -0700, "Ademar" <ademar@nospam.com> wrote: Show quote >Where in the maintenance plan to I specify the number of days or weeks to >keep backups? Doesn't look like it's the "Clean up History" option. > >Thanks, >Ademar. > >"Ademar" <ademar@nospam.com> wrote in message >news:%23euw$AYbGHA.4900@TK2MSFTNGP02.phx.gbl... >>I setup a maintenance plan using the Wizard but it doesn't allow me to >>choose any databases to backup other than the default ones (master, model, >>msdb, tempdb). >> >> Please advise. >> >> Thanks, >> Ademar. >> > In addition to what Sue stated you should think about applying SP1 if you
want to use subfolders for each db. Prior to SP1 you needed separate tasks for each folder. -- Show quoteAndrew J. Kelly SQL MVP "Sue Hoegemeier" <Sue_H@nomail.please> wrote in message news:rkoi52ljn3bgvmp6408191sodvn4thhc6q@4ax.com... > Modify the maintenance plan and add a Maintenance Cleanup > Task. This task allows you to define the conditions you want > to use to delete older backups. > > -Sue > > On Wed, 3 May 2006 15:45:32 -0700, "Ademar" > <ademar@nospam.com> wrote: > >>Where in the maintenance plan to I specify the number of days or weeks to >>keep backups? Doesn't look like it's the "Clean up History" option. >> >>Thanks, >>Ademar. >> >>"Ademar" <ademar@nospam.com> wrote in message >>news:%23euw$AYbGHA.4900@TK2MSFTNGP02.phx.gbl... >>>I setup a maintenance plan using the Wizard but it doesn't allow me to >>>choose any databases to backup other than the default ones (master, >>>model, >>>msdb, tempdb). >>> >>> Please advise. >>> >>> Thanks, >>> Ademar. >>> >> > Is 9.00.1399.06 SP1?
Thanks, Ademar. Show quote "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message news:%23fofbZybGHA.628@TK2MSFTNGP04.phx.gbl... > In addition to what Sue stated you should think about applying SP1 if you > want to use subfolders for each db. Prior to SP1 you needed separate tasks > for each folder. > > -- > Andrew J. Kelly SQL MVP > > > "Sue Hoegemeier" <Sue_H@nomail.please> wrote in message > news:rkoi52ljn3bgvmp6408191sodvn4thhc6q@4ax.com... >> Modify the maintenance plan and add a Maintenance Cleanup >> Task. This task allows you to define the conditions you want >> to use to delete older backups. >> >> -Sue >> >> On Wed, 3 May 2006 15:45:32 -0700, "Ademar" >> <ademar@nospam.com> wrote: >> >>>Where in the maintenance plan to I specify the number of days or weeks to >>>keep backups? Doesn't look like it's the "Clean up History" option. >>> >>>Thanks, >>>Ademar. >>> >>>"Ademar" <ademar@nospam.com> wrote in message >>>news:%23euw$AYbGHA.4900@TK2MSFTNGP02.phx.gbl... >>>>I setup a maintenance plan using the Wizard but it doesn't allow me to >>>>choose any databases to backup other than the default ones (master, >>>>model, >>>>msdb, tempdb). >>>> >>>> Please advise. >>>> >>>> Thanks, >>>> Ademar. >>>> >>> >> > >
http://www.aspfaq.com/sql2005/show.asp?id=20
No that is RTM -- Show quoteAndrew J. Kelly SQL MVP "Ademar" <ademar@nospam.com> wrote in message news:uW5Vs$4bGHA.4604@TK2MSFTNGP02.phx.gbl... > Is 9.00.1399.06 SP1? > > Thanks, > Ademar. > > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message > news:%23fofbZybGHA.628@TK2MSFTNGP04.phx.gbl... >> In addition to what Sue stated you should think about applying SP1 if you >> want to use subfolders for each db. Prior to SP1 you needed separate >> tasks for each folder. >> >> -- >> Andrew J. Kelly SQL MVP >> >> >> "Sue Hoegemeier" <Sue_H@nomail.please> wrote in message >> news:rkoi52ljn3bgvmp6408191sodvn4thhc6q@4ax.com... >>> Modify the maintenance plan and add a Maintenance Cleanup >>> Task. This task allows you to define the conditions you want >>> to use to delete older backups. >>> >>> -Sue >>> >>> On Wed, 3 May 2006 15:45:32 -0700, "Ademar" >>> <ademar@nospam.com> wrote: >>> >>>>Where in the maintenance plan to I specify the number of days or weeks >>>>to >>>>keep backups? Doesn't look like it's the "Clean up History" option. >>>> >>>>Thanks, >>>>Ademar. >>>> >>>>"Ademar" <ademar@nospam.com> wrote in message >>>>news:%23euw$AYbGHA.4900@TK2MSFTNGP02.phx.gbl... >>>>>I setup a maintenance plan using the Wizard but it doesn't allow me to >>>>>choose any databases to backup other than the default ones (master, >>>>>model, >>>>>msdb, tempdb). >>>>> >>>>> Please advise. >>>>> >>>>> Thanks, >>>>> Ademar. >>>>> >>>> >>> >> >> > > Ok I see. A couple more questions please...
Can I put multiple extensions in the "Search folder and delete files based on an extension" field? In the "Folder" field, will it search subfolders? Or do I have to create one plan for each folder? Thanks, Ademar. Show quote "Sue Hoegemeier" <Sue_H@nomail.please> wrote in message news:rkoi52ljn3bgvmp6408191sodvn4thhc6q@4ax.com... > Modify the maintenance plan and add a Maintenance Cleanup > Task. This task allows you to define the conditions you want > to use to delete older backups. > > -Sue > > On Wed, 3 May 2006 15:45:32 -0700, "Ademar" > <ademar@nospam.com> wrote: > >>Where in the maintenance plan to I specify the number of days or weeks to >>keep backups? Doesn't look like it's the "Clean up History" option. >> >>Thanks, >>Ademar. >> >>"Ademar" <ademar@nospam.com> wrote in message >>news:%23euw$AYbGHA.4900@TK2MSFTNGP02.phx.gbl... >>>I setup a maintenance plan using the Wizard but it doesn't allow me to >>>choose any databases to backup other than the default ones (master, >>>model, >>>msdb, tempdb). >>> >>> Please advise. >>> >>> Thanks, >>> Ademar. >>> >> > > Can I put multiple extensions in the "Search folder and delete files based No, you would need to have a separate task for that. One reason I always > on an extension" field? use .bak as an extension for backup files. > In the "Folder" field, will it search subfolders? Or do I have to create One plan for each folder unless you use SP1 then you can delete down one > one plan for each folder? level of sub-folders. -- Show quoteAndrew J. Kelly SQL MVP "Ademar" <ademar@nospam.com> wrote in message news:ehxLO$4bGHA.1516@TK2MSFTNGP05.phx.gbl... > Ok I see. A couple more questions please... > > Can I put multiple extensions in the "Search folder and delete files based > on an extension" field? > > In the "Folder" field, will it search subfolders? Or do I have to create > one plan for each folder? > > Thanks, > Ademar. > > "Sue Hoegemeier" <Sue_H@nomail.please> wrote in message > news:rkoi52ljn3bgvmp6408191sodvn4thhc6q@4ax.com... >> Modify the maintenance plan and add a Maintenance Cleanup >> Task. This task allows you to define the conditions you want >> to use to delete older backups. >> >> -Sue >> >> On Wed, 3 May 2006 15:45:32 -0700, "Ademar" >> <ademar@nospam.com> wrote: >> >>>Where in the maintenance plan to I specify the number of days or weeks to >>>keep backups? Doesn't look like it's the "Clean up History" option. >>> >>>Thanks, >>>Ademar. >>> >>>"Ademar" <ademar@nospam.com> wrote in message >>>news:%23euw$AYbGHA.4900@TK2MSFTNGP02.phx.gbl... >>>>I setup a maintenance plan using the Wizard but it doesn't allow me to >>>>choose any databases to backup other than the default ones (master, >>>>model, >>>>msdb, tempdb). >>>> >>>> Please advise. >>>> >>>> Thanks, >>>> Ademar. >>>> >>> >> > > The default extention for backups is .bak but for transaction logs isn't it
..trn or something like that? Do you change that to .bak as well? Thanks, Ademar. Show quote "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message news:%23xto$R6bGHA.4900@TK2MSFTNGP02.phx.gbl... >> Can I put multiple extensions in the "Search folder and delete files >> based on an extension" field? > > No, you would need to have a separate task for that. One reason I always > use .bak as an extension for backup files. > > >> In the "Folder" field, will it search subfolders? Or do I have to create >> one plan for each folder? > > One plan for each folder unless you use SP1 then you can delete down one > level of sub-folders. > > -- > Andrew J. Kelly SQL MVP > > > "Ademar" <ademar@nospam.com> wrote in message > news:ehxLO$4bGHA.1516@TK2MSFTNGP05.phx.gbl... >> Ok I see. A couple more questions please... >> >> Can I put multiple extensions in the "Search folder and delete files >> based on an extension" field? >> >> In the "Folder" field, will it search subfolders? Or do I have to create >> one plan for each folder? >> >> Thanks, >> Ademar. >> >> "Sue Hoegemeier" <Sue_H@nomail.please> wrote in message >> news:rkoi52ljn3bgvmp6408191sodvn4thhc6q@4ax.com... >>> Modify the maintenance plan and add a Maintenance Cleanup >>> Task. This task allows you to define the conditions you want >>> to use to delete older backups. >>> >>> -Sue >>> >>> On Wed, 3 May 2006 15:45:32 -0700, "Ademar" >>> <ademar@nospam.com> wrote: >>> >>>>Where in the maintenance plan to I specify the number of days or weeks >>>>to >>>>keep backups? Doesn't look like it's the "Clean up History" option. >>>> >>>>Thanks, >>>>Ademar. >>>> >>>>"Ademar" <ademar@nospam.com> wrote in message >>>>news:%23euw$AYbGHA.4900@TK2MSFTNGP02.phx.gbl... >>>>>I setup a maintenance plan using the Wizard but it doesn't allow me to >>>>>choose any databases to backup other than the default ones (master, >>>>>model, >>>>>msdb, tempdb). >>>>> >>>>> Please advise. >>>>> >>>>> Thanks, >>>>> Ademar. >>>>> >>>> >>> >> >> > > Yes. I denote my backup file name with a convention that tells me what type
it is and the extension is always .bak. DD_DBName_FULL_xxxx.bak DD_DBName_DIFF_xxxx.bak DD_DBName_LOG_xxxx.bak -- Show quoteAndrew J. Kelly SQL MVP "Ademar" <ademar@nospam.com> wrote in message news:uopCci6bGHA.3344@TK2MSFTNGP03.phx.gbl... > The default extention for backups is .bak but for transaction logs isn't > it .trn or something like that? Do you change that to .bak as well? > > Thanks, > Ademar. > > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message > news:%23xto$R6bGHA.4900@TK2MSFTNGP02.phx.gbl... >>> Can I put multiple extensions in the "Search folder and delete files >>> based on an extension" field? >> >> No, you would need to have a separate task for that. One reason I always >> use .bak as an extension for backup files. >> >> >>> In the "Folder" field, will it search subfolders? Or do I have to >>> create one plan for each folder? >> >> One plan for each folder unless you use SP1 then you can delete down one >> level of sub-folders. >> >> -- >> Andrew J. Kelly SQL MVP >> >> >> "Ademar" <ademar@nospam.com> wrote in message >> news:ehxLO$4bGHA.1516@TK2MSFTNGP05.phx.gbl... >>> Ok I see. A couple more questions please... >>> >>> Can I put multiple extensions in the "Search folder and delete files >>> based on an extension" field? >>> >>> In the "Folder" field, will it search subfolders? Or do I have to >>> create one plan for each folder? >>> >>> Thanks, >>> Ademar. >>> >>> "Sue Hoegemeier" <Sue_H@nomail.please> wrote in message >>> news:rkoi52ljn3bgvmp6408191sodvn4thhc6q@4ax.com... >>>> Modify the maintenance plan and add a Maintenance Cleanup >>>> Task. This task allows you to define the conditions you want >>>> to use to delete older backups. >>>> >>>> -Sue >>>> >>>> On Wed, 3 May 2006 15:45:32 -0700, "Ademar" >>>> <ademar@nospam.com> wrote: >>>> >>>>>Where in the maintenance plan to I specify the number of days or weeks >>>>>to >>>>>keep backups? Doesn't look like it's the "Clean up History" option. >>>>> >>>>>Thanks, >>>>>Ademar. >>>>> >>>>>"Ademar" <ademar@nospam.com> wrote in message >>>>>news:%23euw$AYbGHA.4900@TK2MSFTNGP02.phx.gbl... >>>>>>I setup a maintenance plan using the Wizard but it doesn't allow me to >>>>>>choose any databases to backup other than the default ones (master, >>>>>>model, >>>>>>msdb, tempdb). >>>>>> >>>>>> Please advise. >>>>>> >>>>>> Thanks, >>>>>> Ademar. >>>>>> >>>>> >>>> >>> >>> >> >> > > I right-click execute the plan and it says it ran successfully but it only
took a couple seconds and don't see any backups. What am I missing here? Thanks, Ademar. Show quote "Ademar" <ademar@nospam.com> wrote in message news:%23euw$AYbGHA.4900@TK2MSFTNGP02.phx.gbl... >I setup a maintenance plan using the Wizard but it doesn't allow me to >choose any databases to backup other than the default ones (master, model, >msdb, tempdb). > > Please advise. > > Thanks, > Ademar. >  |
|||||||||||||||||||||||
Other interesting topics