maintenance plan wizard: older

Showing posts with label older. Show all posts

Friday, March 9, 2012

Maitenance Job

In my Maintenance job I specify to keep the BAK and TRN backups for 1 week.
BAK files are delted that are older than this, however the TRN backups are
not deleted. Why is this and how can I resolve it?Hi ,
Typically, the size of the transaction log file stabilizes when it can hold
the maximum number of transactions that can occur between transaction log
truncations that either checkpoints or transaction log backups trigger.
However, in some situations the transaction log may become very large and
run out of space or become full.
For more information, please refer to:
317375 A transaction log grows unexpectedly or becomes full on a computer
that is running SQL Server
http://support.microsoft.com/default.aspx?scid=kb;EN-US;317375
Best regards,
Vincent Xu
Microsoft Online Partner Support
======================================================Get Secure! - www.microsoft.com/security
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================>>Thread-Topic: Maitenance Job
>>thread-index: AcZn26C5VxQ5EMvgQt6cXAn7hAS36A==>>X-WBNR-Posting-Host: 209.244.152.162
>>From: =?Utf-8?B?R2VvcmdlIFNjaG5laWRlcg==?=<georgedschneider@.news.postalias>
>>Subject: Maitenance Job
>>Date: Mon, 24 Apr 2006 13:14:01 -0700
>>Lines: 3
>>Message-ID: <E2EDCF6E-06F1-4FB2-9918-D80D57D971AF@.microsoft.com>
>>MIME-Version: 1.0
>>Content-Type: text/plain;
>> charset="Utf-8"
>>Content-Transfer-Encoding: 7bit
>>X-Newsreader: Microsoft CDO for Windows 2000
>>Content-Class: urn:content-classes:message
>>Importance: normal
>>Priority: normal
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>>Newsgroups: microsoft.public.sqlserver.server
>>Path: TK2MSFTNGXA01.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:429048
>>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>In my Maintenance job I specify to keep the BAK and TRN backups for 1
week.
>>BAK files are delted that are older than this, however the TRN backups
are
>>not deleted. Why is this and how can I resolve it?|||Did you include databases in simple recovery model in the maint plan?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"George Schneider" <georgedschneider@.news.postalias> wrote in message
news:E2EDCF6E-06F1-4FB2-9918-D80D57D971AF@.microsoft.com...
> In my Maintenance job I specify to keep the BAK and TRN backups for 1 week.
> BAK files are delted that are older than this, however the TRN backups are
> not deleted. Why is this and how can I resolve it?|||what do you mean by simple recovery model
"Tibor Karaszi" wrote:
> Did you include databases in simple recovery model in the maint plan?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "George Schneider" <georgedschneider@.news.postalias> wrote in message
> news:E2EDCF6E-06F1-4FB2-9918-D80D57D971AF@.microsoft.com...
> > In my Maintenance job I specify to keep the BAK and TRN backups for 1 week.
> > BAK files are delted that are older than this, however the TRN backups are
> > not deleted. Why is this and how can I resolve it?
>
>|||The tranactions logs are only like 84 kb when they are backuped up.
"George Schneider" wrote:
> In my Maintenance job I specify to keep the BAK and TRN backups for 1 week.
> BAK files are delted that are older than this, however the TRN backups are
> not deleted. Why is this and how can I resolve it?|||This is very well documented in Books Online (BOL), and I suggest you take the time to learn those
concepts:
BOL 2000, search for "Selecting a Recovery Model"
BOL 2005, search for "Choosing the Recovery Model for a Database"
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"George Schneider" <georgedschneider@.news.postalias> wrote in message
news:1EE7026E-7AB5-41E7-B5E6-F474B3B6A9E0@.microsoft.com...
> what do you mean by simple recovery model
> "Tibor Karaszi" wrote:
>> Did you include databases in simple recovery model in the maint plan?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "George Schneider" <georgedschneider@.news.postalias> wrote in message
>> news:E2EDCF6E-06F1-4FB2-9918-D80D57D971AF@.microsoft.com...
>> > In my Maintenance job I specify to keep the BAK and TRN backups for 1 week.
>> > BAK files are delted that are older than this, however the TRN backups are
>> > not deleted. Why is this and how can I resolve it?
>>|||Hi George ,
How is everything going? Let me know if you still have concerns.
Have a good day.
Best regards,
Vincent Xu
Microsoft Online Partner Support
======================================================Get Secure! - www.microsoft.com/security
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================>>Thread-Topic: Maitenance Job
>>thread-index: AcZoZcp6c/Q/UTZhQfOLwJIjZnhIqA==>>X-WBNR-Posting-Host: 209.244.152.162
>>From: =?Utf-8?B?R2VvcmdlIFNjaG5laWRlcg==?=<georgedschneider@.news.postalias>
>>References: <E2EDCF6E-06F1-4FB2-9918-D80D57D971AF@.microsoft.com>
>>Subject: RE: Maitenance Job
>>Date: Tue, 25 Apr 2006 05:43:02 -0700
>>Lines: 7
>>Message-ID: <C88CCAF2-A7E1-409B-96BA-11C7F6B060F0@.microsoft.com>
>>MIME-Version: 1.0
>>Content-Type: text/plain;
>> charset="Utf-8"
>>Content-Transfer-Encoding: 7bit
>>X-Newsreader: Microsoft CDO for Windows 2000
>>Content-Class: urn:content-classes:message
>>Importance: normal
>>Priority: normal
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>>Newsgroups: microsoft.public.sqlserver.server
>>Path: TK2MSFTNGXA01.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:429121
>>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>The tranactions logs are only like 84 kb when they are backuped up.
>>"George Schneider" wrote:
>> In my Maintenance job I specify to keep the BAK and TRN backups for 1
week.
>> BAK files are delted that are older than this, however the TRN backups
are
>> not deleted. Why is this and how can I resolve it?

Wednesday, March 7, 2012

Maintenance Plans won't allow me to select to delete jobs after 3 days

SQL Server 2000 (SP3A) won't allow me to select to delete any jobs older tha
n 3 days. I don't get the option in the drop down box. When I change to 3
it goes back to 0 and again no option in the drop down box.
I manually went in to job (steps tab) and inserted DAYS next to the 3 and ra
n a sql backup job after this to see if it would delete the jobs older than
3 days. It didn't delete any of them. This is occurring on both the .bak a
nd .trn files, however on t
he reports it is allowing me to select both number of days and days themselv
e. (currently set to 5 days)
This is frustrating as we are now manually deleting jobs so they don't run o
ut of hard drive space when performining nightly backup and maintenance on t
he sql server.
Any help is greatly appreciated. Permissions have been checked etc and ever
ything appears to be accurate.did you try to purge backup files or jobs older than 3 days?
1. maintenance plan will purge backup or trans log backup files after
certain days if you spcify it.
2. it does not purge jobs!
3. why would you create a job then purge it 3 days later?
Steve
"Sheri" <sheri@.isdesign.com> wrote in message
news:F868C089-CDF3-4F25-B750-6227AEBFEE12@.microsoft.com...
> SQL Server 2000 (SP3A) won't allow me to select to delete any jobs older
than 3 days. I don't get the option in the drop down box. When I change to
3 it goes back to 0 and again no option in the drop down box.
> I manually went in to job (steps tab) and inserted DAYS next to the 3 and
ran a sql backup job after this to see if it would delete the jobs older
than 3 days. It didn't delete any of them. This is occurring on both the
.bak and .trn files, however on the reports it is allowing me to select bot
h
number of days and days themselve. (currently set to 5 days)
> This is frustrating as we are now manually deleting jobs so they don't run
out of hard drive space when performining nightly backup and maintenance on
the sql server.
> Any help is greatly appreciated. Permissions have been checked etc and
everything appears to be accurate.
>

Saturday, February 25, 2012

Maintenance Plans - Weeks?

Hi,
When configuring to have a Maintanence Plan remove files older than n
weeks - is that 5-day weeks or 7-day weeks?
Also, is the timing of the file removal based on the timing of the backup or
midnight for the day?
Thanks
Jerry
Hi
7 day week
Backups are removed after the next dump for the specific maintenance plan
has succeeded.
e.g
You configure the plan to remove backups older than 1 day, but you only run
the backup one per week. The backup will remain on disk until the next time
the backup succeeds. In this case, 7 days. If you ran the maintenance plan
job manually after 3 days, it would then remove the backup as the backup
retention period is set to 1 day.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:ugvDTfgbFHA.2936@.tk2msftngp13.phx.gbl...
> Hi,
> When configuring to have a Maintanence Plan remove files older than n
> weeks - is that 5-day weeks or 7-day weeks?
> Also, is the timing of the file removal based on the timing of the backup
> or midnight for the day?
> Thanks
> Jerry
>
|||Thanks Mike.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OFr422gbFHA.2796@.TK2MSFTNGP10.phx.gbl...
> Hi
> 7 day week
> Backups are removed after the next dump for the specific maintenance plan
> has succeeded.
> e.g
> You configure the plan to remove backups older than 1 day, but you only
> run the backup one per week. The backup will remain on disk until the next
> time the backup succeeds. In this case, 7 days. If you ran the maintenance
> plan job manually after 3 days, it would then remove the backup as the
> backup retention period is set to 1 day.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:ugvDTfgbFHA.2936@.tk2msftngp13.phx.gbl...
>

Maintenance Plans - Weeks?

Hi,
When configuring to have a Maintanence Plan remove files older than n
weeks - is that 5-day weeks or 7-day weeks?
Also, is the timing of the file removal based on the timing of the backup or
midnight for the day?
Thanks
JerryHi
7 day week
Backups are removed after the next dump for the specific maintenance plan
has succeeded.
e.g
You configure the plan to remove backups older than 1 day, but you only run
the backup one per week. The backup will remain on disk until the next time
the backup succeeds. In this case, 7 days. If you ran the maintenance plan
job manually after 3 days, it would then remove the backup as the backup
retention period is set to 1 day.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:ugvDTfgbFHA.2936@.tk2msftngp13.phx.gbl...
> Hi,
> When configuring to have a Maintanence Plan remove files older than n
> weeks - is that 5-day weeks or 7-day weeks?
> Also, is the timing of the file removal based on the timing of the backup
> or midnight for the day?
> Thanks
> Jerry
>|||Thanks Mike.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OFr422gbFHA.2796@.TK2MSFTNGP10.phx.gbl...
> Hi
> 7 day week
> Backups are removed after the next dump for the specific maintenance plan
> has succeeded.
> e.g
> You configure the plan to remove backups older than 1 day, but you only
> run the backup one per week. The backup will remain on disk until the next
> time the backup succeeds. In this case, 7 days. If you ran the maintenance
> plan job manually after 3 days, it would then remove the backup as the
> backup retention period is set to 1 day.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:ugvDTfgbFHA.2936@.tk2msftngp13.phx.gbl...
>> Hi,
>> When configuring to have a Maintanence Plan remove files older than n
>> weeks - is that 5-day weeks or 7-day weeks?
>> Also, is the timing of the file removal based on the timing of the backup
>> or midnight for the day?
>> Thanks
>> Jerry
>

Maintenance Plans - Weeks?

Hi,
When configuring to have a Maintanence Plan remove files older than n
weeks - is that 5-day weeks or 7-day weeks?
Also, is the timing of the file removal based on the timing of the backup or
midnight for the day?
Thanks
JerryHi
7 day week
Backups are removed after the next dump for the specific maintenance plan
has succeeded.
e.g
You configure the plan to remove backups older than 1 day, but you only run
the backup one per week. The backup will remain on disk until the next time
the backup succeeds. In this case, 7 days. If you ran the maintenance plan
job manually after 3 days, it would then remove the backup as the backup
retention period is set to 1 day.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:ugvDTfgbFHA.2936@.tk2msftngp13.phx.gbl...
> Hi,
> When configuring to have a Maintanence Plan remove files older than n
> weeks - is that 5-day weeks or 7-day weeks?
> Also, is the timing of the file removal based on the timing of the backup
> or midnight for the day?
> Thanks
> Jerry
>|||Thanks Mike.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OFr422gbFHA.2796@.TK2MSFTNGP10.phx.gbl...
> Hi
> 7 day week
> Backups are removed after the next dump for the specific maintenance plan
> has succeeded.
> e.g
> You configure the plan to remove backups older than 1 day, but you only
> run the backup one per week. The backup will remain on disk until the next
> time the backup succeeds. In this case, 7 days. If you ran the maintenance
> plan job manually after 3 days, it would then remove the backup as the
> backup retention period is set to 1 day.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:ugvDTfgbFHA.2936@.tk2msftngp13.phx.gbl...
>

Maintenance Plans

When you setup a maintenance plan to back up a database and you give it the
option to delete a database older than 1 day. Does it delete the old backup
before it creates the new backup?
After. There's no setting for this, so you cannot change this behavior. Maint plans are totally
reworked in 2005, though.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<Patricia> wrote in message news:OVpW%23yfFGHA.3936@.TK2MSFTNGP12.phx.gbl...
> When you setup a maintenance plan to back up a database and you give it the option to delete a
> database older than 1 day. Does it delete the old backup before it creates the new backup?
>
>
|||The clean up routines will run last unless you have edited the job and
changed the order.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
<Patricia> wrote in message news:OVpW%23yfFGHA.3936@.TK2MSFTNGP12.phx.gbl...
> When you setup a maintenance plan to back up a database and you give it
> the option to delete a database older than 1 day. Does it delete the old
> backup before it creates the new backup?
>
>

Maintenance Plans

When you setup a maintenance plan to back up a database and you give it the
option to delete a database older than 1 day. Does it delete the old backup
before it creates the new backup?After. There's no setting for this, so you cannot change this behavior. Maint plans are totally
reworked in 2005, though.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<Patricia> wrote in message news:OVpW%23yfFGHA.3936@.TK2MSFTNGP12.phx.gbl...
> When you setup a maintenance plan to back up a database and you give it the option to delete a
> database older than 1 day. Does it delete the old backup before it creates the new backup?
>
>|||The clean up routines will run last unless you have edited the job and
changed the order.
--
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
<Patricia> wrote in message news:OVpW%23yfFGHA.3936@.TK2MSFTNGP12.phx.gbl...
> When you setup a maintenance plan to back up a database and you give it
> the option to delete a database older than 1 day. Does it delete the old
> backup before it creates the new backup?
>
>

Monday, February 20, 2012

Maintenance Plans

When you setup a maintenance plan to back up a database and you give it the
option to delete a database older than 1 day. Does it delete the old backup
before it creates the new backup?After. There's no setting for this, so you cannot change this behavior. Main
t plans are totally
reworked in 2005, though.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<Patricia> wrote in message news:OVpW%23yfFGHA.3936@.TK2MSFTNGP12.phx.gbl...
> When you setup a maintenance plan to back up a database and you give it th
e option to delete a
> database older than 1 day. Does it delete the old backup before it create
s the new backup?
>
>|||The clean up routines will run last unless you have edited the job and
changed the order.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
<Patricia> wrote in message news:OVpW%23yfFGHA.3936@.TK2MSFTNGP12.phx.gbl...
> When you setup a maintenance plan to back up a database and you give it
> the option to delete a database older than 1 day. Does it delete the old
> backup before it creates the new backup?
>
>

Friday, March 9, 2012

Maitenance Job

Maitenance Job

Wednesday, March 7, 2012

Maintenance Plans won't allow me to select to delete jobs after 3 days

Saturday, February 25, 2012

Maintenance Plans - Weeks?

Maintenance Plans - Weeks?

Maintenance Plans - Weeks?

Maintenance Plans

Maintenance Plans

Monday, February 20, 2012

Maintenance Plans

maintenance plan wizard

Blog Archive

About Me