|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > dabase maintanence
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 |
dabase maintanence
|
|
| Atso Norppa 2002-11-20, 1:23 am |
| I have sqlserver2000 add there is a problem
with database maintanence. I have configured it that it delete files(dumps)
older than 5 days.
It does not do it. There is 2 weeks history now in my server. Does someone
know is it bug or is there some
tricks i have to do.
Atso
| |
| Dylan Kruger 2002-11-20, 2:23 am |
| Do you mean that you have setup a maintenance plan to backup you databases
and it is not deleteing or clearing old log file backups?
Are you talking about the maintenance plan history , can you be more
specific?
I know there is a problem when you have a maintenance plan to backup the
system and user databases and there is at least one database using the
simple recovery model , this causes the logs nmot getting deleted the
workaround is to create 2 seperate maintenance plans.
one for user databases and one for system, and have them also using the full
or bulk logged recovery model.
If this is not the case can you be more specific?
"Atso Norppa" <atso.norppa@pkkoyj.com> wrote in message
news:arfb69$oao$1@phys-news1.kolumbus.fi...
> I have sqlserver2000 add there is a problem
> with database maintanence. I have configured it that it delete
files(dumps)
> older than 5 days.
> It does not do it. There is 2 weeks history now in my server. Does
someone
> know is it bug or is there some
> tricks i have to do.
>
> Atso
>
>
>
| |
| Joel C. 2002-11-20, 10:24 am |
| This is my issue as well. I'm using 2 maintenance plans:
one that backs up the databases and the second one to back
up the logs. Files older than 2 days are supposed to be
deleted, but they are not. One database, the MSDB is set
to Simple recovery, while the others are set to Full
recovery. This raises another thing: If you are backing
up every night, which databases 'should' be set to Full
and which are fine just using Simple?
joel
joelc@nexuscorp.com
>-----Original Message-----
>Do you mean that you have setup a maintenance plan to
backup you databases
>and it is not deleteing or clearing old log file backups?
>
>Are you talking about the maintenance plan history , can
you be more
>specific?
>
>I know there is a problem when you have a maintenance
plan to backup the
>system and user databases and there is at least one
database using the
>simple recovery model , this causes the logs nmot getting
deleted the
>workaround is to create 2 seperate maintenance plans.
>one for user databases and one for system, and have them
also using the full
>or bulk logged recovery model.
>
>If this is not the case can you be more specific?
>
>"Atso Norppa" <atso.norppa@pkkoyj.com> wrote in message
>news:arfb69$oao$1@phys-news1.kolumbus.fi...
>> I have sqlserver2000 add there is a problem
>> with database maintanence. I have configured it that it
delete
>files(dumps)
>> older than 5 days.
>> It does not do it. There is 2 weeks history now in my
server. Does
>someone
>> know is it bug or is there some
>> tricks i have to do.
>>
>> Atso
>>
>>
>>
>
>
>.
>
| |
| Tibor Karaszi 2002-11-21, 2:23 am |
| > This raises another thing: If you are backing
> up every night, which databases 'should' be set to Full
> and which are fine just using Simple?
I only have master in simple recovery mode. I want to have up-to-date backup of msdb since
backup history is here. Just be aware that when you start the SQLAgent service, it will bring
down msdb to simple (for some strange reason).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Joel C." <joelc@nexuscorp.com> wrote in message
news:bda901c290ad$42877230$8af
82ecf@TK2MSFTNGXA03...
> This is my issue as well. I'm using 2 maintenance plans:
> one that backs up the databases and the second one to back
> up the logs. Files older than 2 days are supposed to be
> deleted, but they are not. One database, the MSDB is set
> to Simple recovery, while the others are set to Full
> recovery. This raises another thing: If you are backing
> up every night, which databases 'should' be set to Full
> and which are fine just using Simple?
>
> joel
> joelc@nexuscorp.com
>
> >-----Original Message-----
> >Do you mean that you have setup a maintenance plan to
> backup you databases
> >and it is not deleteing or clearing old log file backups?
> >
> >Are you talking about the maintenance plan history , can
> you be more
> >specific?
> >
> >I know there is a problem when you have a maintenance
> plan to backup the
> >system and user databases and there is at least one
> database using the
> >simple recovery model , this causes the logs nmot getting
> deleted the
> >workaround is to create 2 seperate maintenance plans.
> >one for user databases and one for system, and have them
> also using the full
> >or bulk logged recovery model.
> >
> >If this is not the case can you be more specific?
> >
> >"Atso Norppa" <atso.norppa@pkkoyj.com> wrote in message
> >news:arfb69$oao$1@phys-news1.kolumbus.fi...
> >> I have sqlserver2000 add there is a problem
> >> with database maintanence. I have configured it that it
> delete
> >files(dumps)
> >> older than 5 days.
> >> It does not do it. There is 2 weeks history now in my
> server. Does
> >someone
> >> know is it bug or is there some
> >> tricks i have to do.
> >>
> >> Atso
> >>
> >>
> >>
> >
> >
> >.
> >
|
|
|
|
|