|
Home > Archive > microsoft.public.sqlserver.server > June 2002 > Transaction Log Backup not working
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 |
Transaction Log Backup not working
|
|
| George 2002-06-22, 8:32 pm |
| I had setup a Database Maintenance Plan via the General
Tab on a database. I have it so it makes a Full backup
every Sunday morning and Transaction Log every hour. The
problem is that on the General Tab it shows the Last
database backup as the correct date. But the Last
transaction log backup shows as a month ago. When I look
at the SQL Server Agent|Jobs it shows the Transaction Log
Job as successful. However if I look at the View Job
History it shows all as taking only 2 seconds. If I show
step details the only thing it has listed is Check Date
and Index Linkage and then deleting old report. Except for
the time of the last backup, the Transaction Log has the
exact time as the Full Backup? Not sure if this was set
up different a month ago? But do I need to create a
separate Maintenance Plan for Full Backups and Transaction
Log Backups?
thanks
george
| |
| Sue Hoegemeier 2002-06-22, 8:32 pm |
| You don't necessarily need separate Maintenance Plans for
this as different jobs are created for the database backup
and the transaction log backup.
If when checking the Maintenace Plan History, you don't find
anything listed for the activity Backup transaction log for
the database, then something may not be right with the
maintenance plan. You also may want to make sure the job and
the job schedule are both enabled. You should be checking
the history through the Maintenance Plan History rather than
through the job history.
Refer to the following for more info:
INF: Troubleshooting Database Maintenance Plan Failures
(Q288577)
http://support.microsoft.com/defaul...b;EN-US;Q288577
-Sue
On Wed, 12 Jun 2002 05:32:38 -0700, "George"
<gdellinger@turborater.com> wrote:
>I had setup a Database Maintenance Plan via the General
>Tab on a database. I have it so it makes a Full backup
>every Sunday morning and Transaction Log every hour. The
>problem is that on the General Tab it shows the Last
>database backup as the correct date. But the Last
>transaction log backup shows as a month ago. When I look
>at the SQL Server Agent|Jobs it shows the Transaction Log
>Job as successful. However if I look at the View Job
>History it shows all as taking only 2 seconds. If I show
>step details the only thing it has listed is Check Date
>and Index Linkage and then deleting old report. Except for
>the time of the last backup, the Transaction Log has the
>exact time as the Full Backup? Not sure if this was set
>up different a month ago? But do I need to create a
>separate Maintenance Plan for Full Backups and Transaction
>Log Backups?
>
>thanks
>george
| |
| George 2002-06-22, 8:32 pm |
| I checked through the Maintenance Plan History and it has:
Backup can not be performed on this database. This sub
task is ignored. It also shows Error Number: 0 but the
Status as Succeeded. The Job is enabled and the schedule
is running hourly.
I will try deleting the Plan and then add it back on...
>-----Original Message-----
>You don't necessarily need separate Maintenance Plans for
>this as different jobs are created for the database backup
>and the transaction log backup.
>If when checking the Maintenace Plan History, you don't
find
>anything listed for the activity Backup transaction log
for
>the database, then something may not be right with the
>maintenance plan. You also may want to make sure the job
and
>the job schedule are both enabled. You should be checking
>the history through the Maintenance Plan History rather
than
>through the job history.
>Refer to the following for more info:
>INF: Troubleshooting Database Maintenance Plan Failures
>(Q288577)
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;Q288577
>
>-Sue
>
>On Wed, 12 Jun 2002 05:32:38 -0700, "George"
><gdellinger@turborater.com> wrote:
>
>>I had setup a Database Maintenance Plan via the General
>>Tab on a database. I have it so it makes a Full backup
>>every Sunday morning and Transaction Log every hour.
The
>>problem is that on the General Tab it shows the Last
>>database backup as the correct date. But the Last
>>transaction log backup shows as a month ago. When I
look
>>at the SQL Server Agent|Jobs it shows the Transaction
Log
>>Job as successful. However if I look at the View Job
>>History it shows all as taking only 2 seconds. If I
show
>>step details the only thing it has listed is Check Date
>>and Index Linkage and then deleting old report. Except
for
>>the time of the last backup, the Transaction Log has the
>>exact time as the Full Backup? Not sure if this was set
>>up different a month ago? But do I need to create a
>>separate Maintenance Plan for Full Backups and
Transaction
>>Log Backups?
>>
>>thanks
>>george
>
>.
>
| |
| Sue Hoegemeier 2002-06-22, 8:32 pm |
| You can get that error if you databae is set to simple
recovery model as this recovery model does not include
transaction logs. If you want to include transaction logs in
your recovery plan, you'd need to change the recovery model
if it's set to simple.
-Sue
On Wed, 12 Jun 2002 06:20:48 -0700, "George"
<gdellinger@turborater.com> wrote:
>I checked through the Maintenance Plan History and it has:
>Backup can not be performed on this database. This sub
>task is ignored. It also shows Error Number: 0 but the
>Status as Succeeded. The Job is enabled and the schedule
>is running hourly.
>
>I will try deleting the Plan and then add it back on...
>
>>-----Original Message-----
>>You don't necessarily need separate Maintenance Plans for
>>this as different jobs are created for the database backup
>>and the transaction log backup.
>>If when checking the Maintenace Plan History, you don't
>find
>>anything listed for the activity Backup transaction log
>for
>>the database, then something may not be right with the
>>maintenance plan. You also may want to make sure the job
>and
>>the job schedule are both enabled. You should be checking
>>the history through the Maintenance Plan History rather
>than
>>through the job history.
>>Refer to the following for more info:
>>INF: Troubleshooting Database Maintenance Plan Failures
>>(Q288577)
>>http://support.microsoft.com/default.aspx?scid=kb;EN-
>US;Q288577
>>
>>-Sue
>>
>>On Wed, 12 Jun 2002 05:32:38 -0700, "George"
>><gdellinger@turborater.com> wrote:
>>
>>>I had setup a Database Maintenance Plan via the General
>>>Tab on a database. I have it so it makes a Full backup
>>>every Sunday morning and Transaction Log every hour.
> The
>>>problem is that on the General Tab it shows the Last
>>>database backup as the correct date. But the Last
>>>transaction log backup shows as a month ago. When I
> look
>>>at the SQL Server Agent|Jobs it shows the Transaction
> Log
>>>Job as successful. However if I look at the View Job
>>>History it shows all as taking only 2 seconds. If I
> show
>>>step details the only thing it has listed is Check Date
>>>and Index Linkage and then deleting old report. Except
> for
>>>the time of the last backup, the Transaction Log has the
>>>exact time as the Full Backup? Not sure if this was set
>>>up different a month ago? But do I need to create a
>>>separate Maintenance Plan for Full Backups and
> Transaction[color
=darkred]
>>>Log Backups?
>>>
>>>thanks
>>>george
>>
>>.
>>[/color]
| |
| george 2002-06-22, 8:32 pm |
| Deleting the Maintenance Plan and adding back on did not
resolve the problem. It still gives the error "Backup can
not be performed on this database. This sub task is
ignored". Any ideas?
>-----Original Message-----
>You don't necessarily need separate Maintenance Plans for
>this as different jobs are created for the database backup
>and the transaction log backup.
>If when checking the Maintenace Plan History, you don't
find
>anything listed for the activity Backup transaction log
for
>the database, then something may not be right with the
>maintenance plan. You also may want to make sure the job
and
>the job schedule are both enabled. You should be checking
>the history through the Maintenance Plan History rather
than
>through the job history.
>Refer to the following for more info:
>INF: Troubleshooting Database Maintenance Plan Failures
>(Q288577)
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;Q288577
>
>-Sue
>
>On Wed, 12 Jun 2002 05:32:38 -0700, "George"
><gdellinger@turborater.com> wrote:
>
>>I had setup a Database Maintenance Plan via the General
>>Tab on a database. I have it so it makes a Full backup
>>every Sunday morning and Transaction Log every hour.
The
>>problem is that on the General Tab it shows the Last
>>database backup as the correct date. But the Last
>>transaction log backup shows as a month ago. When I
look
>>at the SQL Server Agent|Jobs it shows the Transaction
Log
>>Job as successful. However if I look at the View Job
>>History it shows all as taking only 2 seconds. If I
show
>>step details the only thing it has listed is Check Date
>>and Index Linkage and then deleting old report. Except
for
>>the time of the last backup, the Transaction Log has the
>>exact time as the Full Backup? Not sure if this was set
>>up different a month ago? But do I need to create a
>>separate Maintenance Plan for Full Backups and
Transaction
>>Log Backups?
>>
>>thanks
>>george
>
>.
>
| |
| george 2002-06-22, 8:32 pm |
| Where is this setting located? I'll look around...but I
don't think I have ever seen this before.
thanks,
george
>-----Original Message-----
>You can get that error if you databae is set to simple
>recovery model as this recovery model does not include
>transaction logs. If you want to include transaction logs
in
>your recovery plan, you'd need to change the recovery
model
>if it's set to simple.
>
>-Sue
>
>On Wed, 12 Jun 2002 06:20:48 -0700, "George"
><gdellinger@turborater.com> wrote:
>
>>I checked through the Maintenance Plan History and it
has:
>>Backup can not be performed on this database. This sub
>>task is ignored. It also shows Error Number: 0 but the
>>Status as Succeeded. The Job is enabled and the schedule
>>is running hourly.
>>
>>I will try deleting the Plan and then add it back on...
>>
>>>-----Original Message-----
>>>You don't necessarily need separate Maintenance Plans
for[c
olor=darkred]
>>>this as different jobs are created for the database[/color]
backup
>>>and the transaction log backup.
>>>If when checking the Maintenace Plan History, you don't
>>find
>>>anything listed for the activity Backup transaction log
>>for
>>>the database, then something may not be right with the
>>>maintenance plan. You also may want to make sure the
job
>>and
>>>the job schedule are both enabled. You should be
checking
>>>the history through the Maintenance Plan History rather
>>than
>>>through the job history.
>>>Refer to the following for more info:
>>>INF: Troubleshooting Database Maintenance Plan Failures
>>>(Q288577)
>>>http://support.microsoft.com/default.aspx?scid=kb;EN-
>>US;Q288577
>>>
>>>-Sue
>>>
>>>On Wed, 12 Jun 2002 05:32:38 -0700, "George"
>>><gdellinger@turborater.com> wrote:
>>>
>>>>I had setup a Database Maintenance Plan via the
General
>>>>Tab on a database. I have it so it makes a Full
backup
>>>>every Sunday morning and Transaction Log every hour.
>>The
>>>>problem is that on the General Tab it shows the Last
>>>>database backup as the correct date. But the Last
>>>>transaction log backup shows as a month ago. When I
>>look
>>>>at the SQL Server Agent|Jobs it shows the Transaction
>>Log
>>>>Job as successful. However if I look at the View Job
>>>>History it shows all as taking only 2 seconds. If I
>>show
>>>>step details the only thing it has listed is Check
Date[
color=darkred]
>>>>and Index Linkage and then deleting old report. Except
>>for
>>>>the time of the last backup, the Transaction Log has[/color]
the[c
olor=darkred]
>>>>exact time as the Full Backup? Not sure if this was[/color]
set[c
olor=darkred]
>>>>up different a month ago? But do I need to create a
>>>>separate Maintenance Plan for Full Backups and
>>Transaction
>>>>Log Backups?
>>>>
>>>>thanks
>>>>george
>>>
>>>.
>>>
>
>.
>[/color]
| |
| george 2002-06-22, 8:32 pm |
| Sorry I did not mention this earlier, but I am running SQL
7. I just did a search and found this was a new feature
added to SQL 2000...so I guess that's why I have never
seen that setting. Any other ideas?
>-----Original Message-----
>You can get that error if you databae is set to simple
>recovery model as this recovery model does not include
>transaction logs. If you want to include transaction logs
in
>your recovery plan, you'd need to change the recovery
model
>if it's set to simple.
>
>-Sue
>
>On Wed, 12 Jun 2002 06:20:48 -0700, "George"
><gdellinger@turborater.com> wrote:
>
>>I checked through the Maintenance Plan History and it
has:
>>Backup can not be performed on this database. This sub
>>task is ignored. It also shows Error Number: 0 but the
>>Status as Succeeded. The Job is enabled and the schedule
>>is running hourly.
>>
>>I will try deleting the Plan and then add it back on...
>>
>>>-----Original Message-----
>>>You don't necessarily need separate Maintenance Plans
for[c
olor=darkred]
>>>this as different jobs are created for the database[/color]
backup
>>>and the transaction log backup.
>>>If when checking the Maintenace Plan History, you don't
>>find
>>>anything listed for the activity Backup transaction log
>>for
>>>the database, then something may not be right with the
>>>maintenance plan. You also may want to make sure the
job
>>and
>>>the job schedule are both enabled. You should be
checking
>>>the history through the Maintenance Plan History rather
>>than
>>>through the job history.
>>>Refer to the following for more info:
>>>INF: Troubleshooting Database Maintenance Plan Failures
>>>(Q288577)
>>>http://support.microsoft.com/default.aspx?scid=kb;EN-
>>US;Q288577
>>>
>>>-Sue
>>>
>>>On Wed, 12 Jun 2002 05:32:38 -0700, "George"
>>><gdellinger@turborater.com> wrote:
>>>
>>>>I had setup a Database Maintenance Plan via the
General
>>>>Tab on a database. I have it so it makes a Full
backup
>>>>every Sunday morning and Transaction Log every hour.
>>The
>>>>problem is that on the General Tab it shows the Last
>>>>database backup as the correct date. But the Last
>>>>transaction log backup shows as a month ago. When I
>>look
>>>>at the SQL Server Agent|Jobs it shows the Transaction
>>Log
>>>>Job as successful. However if I look at the View Job
>>>>History it shows all as taking only 2 seconds. If I
>>show
>>>>step details the only thing it has listed is Check
Date[
color=darkred]
>>>>and Index Linkage and then deleting old report. Except
>>for
>>>>the time of the last backup, the Transaction Log has[/color]
the[c
olor=darkred]
>>>>exact time as the Full Backup? Not sure if this was[/color]
set[c
olor=darkred]
>>>>up different a month ago? But do I need to create a
>>>>separate Maintenance Plan for Full Backups and
>>Transaction
>>>>Log Backups?
>>>>
>>>>thanks
>>>>george
>>>
>>>.
>>>
>
>.
>[/color]
| |
| Sue Hoegemeier 2002-06-22, 8:32 pm |
| In Enterprise Manager, check your database properties,
option tab.
In Query Analyzer, execute:
exec sp_dboption 'YourDatabase', 'trunc. log on chkpt.'
-Sue
On Wed, 12 Jun 2002 06:56:32 -0700, "george"
<gdellinger@turborater.com> wrote:
>Where is this setting located? I'll look around...but I
>don't think I have ever seen this before.
>
>thanks,
>george
>
>>-----Original Message-----
>>You can get that error if you databae is set to simple
>>recovery model as this recovery model does not include
>>transaction logs. If you want to include transaction logs
>in
>>your recovery plan, you'd need to change the recovery
>model
>>if it's set to simple.
>>
>>-Sue
>>
>>On Wed, 12 Jun 2002 06:20:48 -0700, "George"
>><gdellinger@turborater.com> wrote:
>>
>>>I checked through the Maintenance Plan History and it
> has:
>>>Backup can not be performed on this database. This sub
>>>task is ignored. It also shows Error Number: 0 but the
>>>Status as Succeeded. The Job is enabled and the schedule
>>>is running hourly.
>>>
>>>I will try deleting the Plan and then add it back on...
>>>
>>>>-----Original Message-----
>>>>You don't necessarily need separate Maintenance Plans
> for
>>>>this as different jobs are created for the database
> backup
>>>>and the transaction log backup.
>>>>If when checking the Maintenace Plan History, you don't
>>>find
>>>>anything listed for the activity Backup transaction log
>>>for
>>>>the database, then something may not be right with the
>>>>maintenance plan. You also may want to make sure the
> job
>>>and
>>>>the job schedule are both enabled. You should be
> checking
>>>>the history through the Maintenance Plan History rather
>>>than
>>>>through the job history.
>>>>Refer to the following for more info:
>>>>INF: Troubleshooting Database Maintenance Plan Failures
>>>>(Q288577)
>>>>http://support.microsoft.com/default.aspx?scid=kb;EN-
>>>US;Q288577
>>>>
>>>>-Sue
>>>>
>>>>On Wed, 12 Jun 2002 05:32:38 -0700, "George"
>>>><gdellinger@turborater.com> wrote:
>>>>
>>>>>I had setup a Database Maintenance Plan via the
> General
>>>>>Tab on a database. I have it so it makes a Full
> backup
>>>>>every Sunday morning and Transaction Log every hour.
>>>The
>>>>>problem is that on the General Tab it shows the Last
>>>>>database backup as the correct date. But the Last
>>>>>transaction log backup shows as a month ago. When I
>>>look
>>>>>at the SQL Server Agent|Jobs it shows the Transaction
>>>Log
>>>>>Job as successful. However if I look at the View Job
>>>>>History it shows all as taking only 2 seconds. If I
>>>show
>>>>>step details the only thing it has listed is Check
> Date
>>>>>and Index Linkage and then deleting old report. Except
>>>for
>>>>>the time of the last backup, the Transaction Log has
> the
>>>>>exact time as the Full Backup? Not sure if this was
> set
>>>>>up different a month ago? But do I need to create a
>>>>>separate Maintenance Plan for Full Backups and
>>>Transaction
>>>>>Log Backups?
>>>>>
>>>>>thanks
>>>>>george
>>>>
>>>>.
>>>>
>>
>>.
>>
| |
| Tibor Karaszi 2002-06-22, 8:32 pm |
| Presuming SQL 2000:
Right-click your database. Properties. Options.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"george" <gdellinger@turborater.com> wrote in message
news:ecb301c21218$f52b35c0$35e
f2ecf@TKMSFTNGXA11...
> Where is this setting located? I'll look around...but I
> don't think I have ever seen this before.
>
> thanks,
> george
>
> >-----Original Message-----
> >You can get that error if you databae is set to simple
> >recovery model as this recovery model does not include
> >transaction logs. If you want to include transaction logs
> in
> >your recovery plan, you'd need to change the recovery
> model
> >if it's set to simple.
> >
> >-Sue
> >
> >On Wed, 12 Jun 2002 06:20:48 -0700, "George"
> ><gdellinger@turborater.com> wrote:
> >
> >>I checked through the Maintenance Plan History and it
> has:
> >>Backup can not be performed on this database. This sub
> >>task is ignored. It also shows Error Number: 0 but the
> >>Status as Succeeded. The Job is enabled and the schedule
> >>is running hourly.
> >>
> >>I will try deleting the Plan and then add it back on...
> >>
> >>>-----Original Message-----
> >>>You don't necessarily need separate Maintenance Plans
> for
> >>>this as different jobs are created for the database
> backup
> >>>and the transaction log backup.
> >>>If when checking the Maintenace Plan History, you don't
> >>find
> >>>anything listed for the activity Backup transaction log
> >>for
> >>>the database, then something may not be right with the
> >>>maintenance plan. You also may want to make sure the
> job
> >>and
> >>>the job schedule are both enabled. You should be
> checking
> >>>the history through the Maintenance Plan History rather
> >>than
> >>>through the job history.
> >>>Refer to the following for more info:
> >>>INF: Troubleshooting Database Maintenance Plan Failures
> >>>(Q288577)
> >>>http://support.microsoft.com/default.aspx?scid=kb;EN-
> >>US;Q288577
> >>>
> >>>-Sue
> >>>
> >>>On Wed, 12 Jun 2002 05:32:38 -0700, "George"
> >>><gdellinger@turborater.com> wrote:
> >>>
> >>>>I had setup a Database Maintenance Plan via the
> General
> >>>>Tab on a database. I have it so it makes a Full
> backup
> >>>>every Sunday morning and Transaction Log every hour.
> >>The
> >>>>problem is that on the General Tab it shows the Last
> >>>>database backup as the correct date. But the Last
> >>>>transaction log backup shows as a month ago. When I
> >>look
> >>>>at the SQL Server Agent|Jobs it shows the Transaction
> >>Log
> >>>>Job as successful. However if I look at the View Job
> >>>>History it shows all as taking only 2 seconds. If I
> >>show
> >>>>step details the only thing it has listed is Check
> Date
> >>>>and Index Linkage and then deleting old report. Except
> >>for
> >>>>the time of the last backup, the Transaction Log has
> the
> >>>>exact time as the Full Backup? Not sure if this was
> set
> >>>>up different a month ago? But do I need to create a
> >>>>separate Maintenance Plan for Full Backups and
> >>Transaction
> >>>>Log Backups?
> >>>>
> >>>>thanks
> >>>>george
> >>>
> >>>.
> >>>
> >
> >.
> >
| |
| george 2002-06-22, 8:32 pm |
| thanks
I had just posted that I had forgotten to mention that I=20
had SQL 7. After searching google found that this was a=20
feature added to SQL 2000. Any other ideas?
>-----Original Message-----
>Presuming SQL 2000:
>
>Right-click your database. Properties. Options.
>
>--
>Tibor Karaszi, SQL Server MVP
>Archive at: http://groups.google.com/groups?
oi=3Ddjq&as_ugroup=3Dmicrosoft.public.sqlserver
>
>
>"george" <gdellinger@turborater.com> wrote in message
> news:ecb301c21218$f52b35c0$35e
f2ecf@TKMSFTNGXA11...
>> Where is this setting located? I'll look around...but I
>> don't think I have ever seen this before.
>>
>> thanks,
>> george
>>
>> >-----Original Message-----
>> >You can get that error if you databae is set to simple
>> >recovery model as this recovery model does not include
>> >transaction logs. If you want to include transaction=20
logs
>> in
>> >your recovery plan, you'd need to change the recovery
>> model
>> >if it's set to simple.
>> >
>> >-Sue
>> >
>> >On Wed, 12 Jun 2002 06:20:48 -0700, "George"
>> ><gdellinger@turborater.com> wrote:
>> >
>> >>I checked through the Maintenance Plan History and it
>> has:
>> >>Backup can not be performed on this database. This sub
>> >>task is ignored. It also shows Error Number: 0 but the
>> >>Status as Succeeded. The Job is enabled and the=20
schedule
>> >>is running hourly.
>> >>
>> >>I will try deleting the Plan and then add it back=20
on... [colo
r=darkred]
>> >>
>> >>>-----Original Message-----
>> >>>You don't necessarily need separate Maintenance Plans
>> for
>> >>>this as different jobs are created for the database
>> backup
>> >>>and the transaction log backup.
>> >>>If when checking the Maintenace Plan History, you=20[/color]
don't
>> >>find
>> >>>anything listed for the activity Backup transaction=20
log[c
olor=darkred]
>> >>for
>> >>>the database, then something may not be right with=20[/color]
the[c
olor=darkred]
>> >>>maintenance plan. You also may want to make sure the
>> job
>> >>and
>> >>>the job schedule are both enabled. You should be
>> checking
>> >>>the history through the Maintenance Plan History=20[/color]
rather
>> >>than
>> >>>through the job history.
>> >>>Refer to the following for more info:
>> >>>INF: Troubleshooting Database Maintenance Plan=20
Failures
>> >>>(Q288577)
>> >>>http://support.microsoft.com/default.aspx?scid=3Dkb;EN-
>> >>US;Q288577
>> >>>
>> >>>-Sue
>> >>>
>> >>>On Wed, 12 Jun 2002 05:32:38 -0700, "George"
>> >>><gdellinger@turborater.com> wrote:
>> >>>
>> >>>>I had setup a Database Maintenance Plan via the
>> General
>> >>>>Tab on a database. I have it so it makes a Full
>> backup
>> >>>>every Sunday morning and Transaction Log every hour.
>> >>The
>> >>>>problem is that on the General Tab it shows the Last
>> >>>>database backup as the correct date. But the Last
>> >>>>transaction log backup shows as a month ago. When I
>> >>look
>> >>>>at the SQL Server Agent|Jobs it shows the=20
Transaction
>> >>Log
>> >>>>Job as successful. However if I look at the View Job
>> >>>>History it shows all as taking only 2 seconds. If I
>> >>show
>> >>>>step details the only thing it has listed is Check
>> Date
>> >>>>and Index Linkage and then deleting old report.=20
Except
>> >>for
>> >>>>the time of the last backup, the Transaction Log has
>> the
>> >>>>exact time as the Full Backup? Not sure if this was
>> set
>> >>>>up different a month ago? But do I need to create a
>> >>>>separate Maintenance Plan for Full Backups and
>> >>Transaction
>> >>>>Log Backups?
>> >>>>
>> >>>>thanks
>> >>>>george
>> > =CD{=9Dw=C0=1FZ=04=B4=A2%H$^#H
TCd=0C =EC=D4=07>>
>> >>>.
>> >>>
>> >
>> >.
>> >
>
>
>.
>
| |
| Sue Hoegemeier 2002-06-22, 8:32 pm |
| It's not really a new feature - it's the equivalent of
truncate log on checkpoint on SQL Server 7.
-Sue
On Wed, 12 Jun 2002 07:04:50 -0700, "george"
<gdellinger@turborater.com> wrote:
>Sorry I did not mention this earlier, but I am running SQL
>7. I just did a search and found this was a new feature
>added to SQL 2000...so I guess that's why I have never
>seen that setting. Any other ideas?
>
>>-----Original Message-----
>>You can get that error if you databae is set to simple
>>recovery model as this recovery model does not include
>>transaction logs. If you want to include transaction logs
>in
>>your recovery plan, you'd need to change the recovery
>model
>>if it's set to simple.
>>
>>-Sue
>>
>>On Wed, 12 Jun 2002 06:20:48 -0700, "George"
>><gdellinger@turborater.com> wrote:
>>
>>>I checked through the Maintenance Plan History and it
> has:
>>>Backup can not be performed on this database. This sub
>>>task is ignored. It also shows Error Number: 0 but the
>>>Status as Succeeded. The Job is enabled and the schedule
>>>is running hourly.
>>>
>>>I will try deleting the Plan and then add it back on...
>>>
>>>>-----Original Message-----
>>>>You don't necessarily need separate Maintenance Plans
> for
>>>>this as different jobs are created for the database
> backup
>>>>and the transaction log backup.
>>>>If when checking the Maintenace Plan History, you don't
>>>find
>>>>anything listed for the activity Backup transaction log
>>>for
>>>>the database, then something may not be right with the
>>>>maintenance plan. You also may want to make sure the
> job
>>>and
>>>>the job schedule are both enabled. You should be
> checking
>>>>the history through the Maintenance Plan History rather
>>>than
>>>>through the job history.
>>>>Refer to the following for more info:
>>>>INF: Troubleshooting Database Maintenance Plan Failures
>>>>(Q288577)
>>>>http://support.microsoft.com/default.aspx?scid=kb;EN-
>>>US;Q288577
>>>>
>>>>-Sue
>>>>
>>>>On Wed, 12 Jun 2002 05:32:38 -0700, "George"
>>>><gdellinger@turborater.com> wrote:
>>>>
>>>>>I had setup a Database Maintenance Plan via the
> General
>>>>>Tab on a database. I have it so it makes a Full
> backup
>>>>>every Sunday morning and Transaction Log every hour.
>>>The
>>>>>problem is that on the General Tab it shows the Last
>>>>>database backup as the correct date. But the Last
>>>>>transaction log backup shows as a month ago. When I
>>>look
>>>>>at the SQL Server Agent|Jobs it shows the Transaction
>>>Log
>>>>>Job as successful. However if I look at the View Job
>>>>>History it shows all as taking only 2 seconds. If I
>>>show
>>>>>step details the only thing it has listed is Check
> Date
>>>>>and Index Linkage and then deleting old report. Except
>>>for
>>>>>the time of the last backup, the Transaction Log has
> the
>>>>>exact time as the Full Backup? Not sure if this was
> set
>>>>>up different a month ago? But do I need to create a
>>>>>separate Maintenance Plan for Full Backups and
>>>Transaction
>>>>>Log Backups?
>>>>>
>>>>>thanks
>>>>>george
>>>>
>>>>.
>>>>
>>
>>.
>>
| |
| george 2002-06-22, 8:32 pm |
| I executed the command
OptionName CurrentSetting
----------------------------------- --------------
trunc. log on chkpt. ON
Should this option be off?
Just checking...but did you see the post of above this one
stating I was running SQL 7?
>-----Original Message-----
>In Enterprise Manager, check your database properties,
>option tab.
>In Query Analyzer, execute:
>exec sp_dboption 'YourDatabase', 'trunc. log on chkpt.'
>
>-Sue
>
>On Wed, 12 Jun 2002 06:56:32 -0700, "george"
><gdellinger@turborater.com> wrote:
>
>>Where is this setting located? I'll look around...but I
>>don't think I have ever seen this before.
>>
>>thanks,
>>george
>>
>>>-----Original Message-----
>>>You can get that error if you databae is set to simple
>>>recovery model as this recovery model does not include
>>>transaction logs. If you want to include transaction
logs
>>in
>>>your recovery plan, you'd need to change the recovery
>>model
>>>if it's set to simple.
>>>
>>>-Sue
>>>
>>>On Wed, 12 Jun 2002 06:20:48 -0700, "George"
>>><gdellinger@turborater.com> wrote:
>>>
>>>>I checked through the Maintenance Plan History and it
>>has:
>>>>Backup can not be performed on this database. This sub
>>>>task is ignored. It also shows Error Number: 0 but the
>>>>Status as Succeeded. The Job is enabled and the
schedule
>>>>is running hourly.
>>>>
>>>>I will try deleting the Plan and then add it back on...
>>>>
>>>>>-----Original Message-----
>>>>>You don't necessarily need separate Maintenance Plans
>>for
>>>>>this as different jobs are created for the database
>>backup
>>>>>and the transaction log backup.
>>>>>If when checking the Maintenace Plan History, you
don't
>>>>find
>>>>>anything listed for the activity Backup transaction
log[c
olor=darkred]
>>>>for
>>>>>the database, then something may not be right with the
>>>>>maintenance plan. You also may want to make sure the
>>job
>>>>and
>>>>>the job schedule are both enabled. You should be
>>checking
>>>>>the history through the Maintenance Plan History[/color]
rather
>>>>than
>>>>>through the job history.
>>>>>Refer to the following for more info:
>>>>>INF: Troubleshooting Database Maintenance Plan
Failures
>>>>>(Q288577)
>>>>>http://support.microsoft.com/default.aspx?scid=kb;EN-
>>>>US;Q288577
>>>>>
>>>>>-Sue
>>>>>
>>>>>On Wed, 12 Jun 2002 05:32:38 -0700, "George"
>>>>><gdellinger@turborater.com> wrote:
>>>>>
>>>>>>I had setup a Database Maintenance Plan via the
>>General
>>>>>>Tab on a database. I have it so it makes a Full
>>backup
>>>>>>every Sunday morning and Transaction Log every
hour. [colo
r=darkred]
>>>>The
>>>>>>problem is that on the General Tab it shows the Last
>>>>>>database backup as the correct date. But the Last
>>>>>>transaction log backup shows as a month ago. When I
>>>>look
>>>>>>at the SQL Server Agent|Jobs it shows the[/color]
Transaction
>>>>Log
>>>>>>Job as successful. However if I look at the View Job
>>>>>>History it shows all as taking only 2 seconds. If I
>>>>show
>>>>>>step details the only thing it has listed is Check
>>Date
>>>>>>and Index Linkage and then deleting old report.
Except
>>>>for
>>>>>>the time of the last backup, the Transaction Log has
>>the
>>>>>>exact time as the Full Backup? Not sure if this was
>>set
>>>>>>up different a month ago? But do I need to create a
>>>>>>separate Maintenance Plan for Full Backups and
>>>>Transaction
>>>>>>Log Backups?
>>>>>>
>>>>>>thanks
>>>>>>george
>>>>>
>>>>>.
>>>>>
>>>
>>>.
>>>
>
>.
>
| |
| george 2002-06-22, 8:32 pm |
| Sorry for the web of posts.
So does having the truncate log on checkpoint CHECKED make
the recovery model simple? I will try unchecking this and
running the job again.
>-----Original Message-----
>It's not really a new feature - it's the equivalent of
>truncate log on checkpoint on SQL Server 7.
>
>-Sue
>
>On Wed, 12 Jun 2002 07:04:50 -0700, "george"
><gdellinger@turborater.com> wrote:
>
>>Sorry I did not mention this earlier, but I am running
SQL
>>7. I just did a search and found this was a new feature
>>added to SQL 2000...so I guess that's why I have never
>>seen that setting. Any other ideas?
>>
>>>-----Original Message-----
>>>You can get that error if you databae is set to simple
>>>recovery model as this recovery model does not include
>>>transaction logs. If you want to include transaction
logs
>>in
>>>your recovery plan, you'd need to change the recovery
>>model
>>>if it's set to simple.
>>>
>>>-Sue
>>>
>>>On Wed, 12 Jun 2002 06:20:48 -0700, "George"
>>><gdellinger@turborater.com> wrote:
>>>
>>>>I checked through the Maintenance Plan History and it
>>has:
>>>>Backup can not be performed on this database. This sub
>>>>task is ignored. It also shows Error Number: 0 but the
>>>>Status as Succeeded. The Job is enabled and the
schedule
>>>>is running hourly.
>>>>
>>>>I will try deleting the Plan and then add it back on...
>>>>
>>>>>-----Original Message-----
>>>>>You don't necessarily need separate Maintenance Plans
>>for
>>>>>this as different jobs are created for the database
>>backup
>>>>>and the transaction log backup.
>>>>>If when checking the Maintenace Plan History, you
don't
>>>>find
>>>>>anything listed for the activity Backup transaction
log[c
olor=darkred]
>>>>for
>>>>>the database, then something may not be right with the
>>>>>maintenance plan. You also may want to make sure the
>>job
>>>>and
>>>>>the job schedule are both enabled. You should be
>>checking
>>>>>the history through the Maintenance Plan History[/color]
rather
>>>>than
>>>>>through the job history.
>>>>>Refer to the following for more info:
>>>>>INF: Troubleshooting Database Maintenance Plan
Failures
>>>>>(Q288577)
>>>>>http://support.microsoft.com/default.aspx?scid=kb;EN-
>>>>US;Q288577
>>>>>
>>>>>-Sue
>>>>>
>>>>>On Wed, 12 Jun 2002 05:32:38 -0700, "George"
>>>>><gdellinger@turborater.com> wrote:
>>>>>
>>>>>>I had setup a Database Maintenance Plan via the
>>General
>>>>>>Tab on a database. I have it so it makes a Full
>>backup
>>>>>>every Sunday morning and Transaction Log every
hour. [colo
r=darkred]
>>>>The
>>>>>>problem is that on the General Tab it shows the Last
>>>>>>database backup as the correct date. But the Last
>>>>>>transaction log backup shows as a month ago. When I
>>>>look
>>>>>>at the SQL Server Agent|Jobs it shows the[/color]
Transaction
>>>>Log
>>>>>>Job as successful. However if I look at the View Job
>>>>>>History it shows all as taking only 2 seconds. If I
>>>>show
>>>>>>step details the only thing it has listed is Check
>>Date
>>>>>>and Index Linkage and then deleting old report.
Except
>>>>for
>>>>>>the time of the last backup, the Transaction Log has
>>the
>>>>>>exact time as the Full Backup? Not sure if this was
>>set
>>>>>>up different a month ago? But do I need to create a
>>>>>>separate Maintenance Plan for Full Backups and
>>>>Transaction
>>>>>>Log Backups?
>>>>>>
>>>>>>thanks
>>>>>>george
>>>>>
>>>>>.
>>>>>
>>>
>>>.
>>>
>
>.
>
| |
| george 2002-06-22, 8:32 pm |
| Sue,
Thank you so very much. I unchecked the truncate log on
checkpoint and it just succesfully made a backup of the
transaction log. Took 10 minutes. I feel much better now.
thanks,
george
>-----Original Message-----
>It's not really a new feature - it's the equivalent of
>truncate log on checkpoint on SQL Server 7.
>
>-Sue
>
>On Wed, 12 Jun 2002 07:04:50 -0700, "george"
><gdellinger@turborater.com> wrote:
>
>>Sorry I did not mention this earlier, but I am running
SQL
>>7. I just did a search and found this was a new feature
>>added to SQL 2000...so I guess that's why I have never
>>seen that setting. Any other ideas?
>>
>>>-----Original Message-----
>>>You can get that error if you databae is set to simple
>>>recovery model as this recovery model does not include
>>>transaction logs. If you want to include transaction
logs
>>in
>>>your recovery plan, you'd need to change the recovery
>>model
>>>if it's set to simple.
>>>
>>>-Sue
>>>
>>>On Wed, 12 Jun 2002 06:20:48 -0700, "George"
>>><gdellinger@turborater.com> wrote:
>>>
>>>>I checked through the Maintenance Plan History and it
>>has:
>>>>Backup can not be performed on this database. This sub
>>>>task is ignored. It also shows Error Number: 0 but the
>>>>Status as Succeeded. The Job is enabled and the
schedule
>>>>is running hourly.
>>>>
>>>>I will try deleting the Plan and then add it back on...
>>>>
>>>>>-----Original Message-----
>>>>>You don't necessarily need separate Maintenance Plans
>>for
>>>>>this as different jobs are created for the database
>>backup
>>>>>and the transaction log backup.
>>>>>If when checking the Maintenace Plan History, you
don't
>>>>find
>>>>>anything listed for the activity Backup transaction
log[c
olor=darkred]
>>>>for
>>>>>the database, then something may not be right with the
>>>>>maintenance plan. You also may want to make sure the
>>job
>>>>and
>>>>>the job schedule are both enabled. You should be
>>checking
>>>>>the history through the Maintenance Plan History[/color]
rather
>>>>than
>>>>>through the job history.
>>>>>Refer to the following for more info:
>>>>>INF: Troubleshooting Database Maintenance Plan
Failures
>>>>>(Q288577)
>>>>>http://support.microsoft.com/default.aspx?scid=kb;EN-
>>>>US;Q288577
>>>>>
>>>>>-Sue
>>>>>
>>>>>On Wed, 12 Jun 2002 05:32:38 -0700, "George"
>>>>><gdellinger@turborater.com> wrote:
>>>>>
>>>>>>I had setup a Database Maintenance Plan via the
>>General
>>>>>>Tab on a database. I have it so it makes a Full
>>backup
>>>>>>every Sunday morning and Transaction Log every
hour. [colo
r=darkred]
>>>>The
>>>>>>problem is that on the General Tab it shows the Last
>>>>>>database backup as the correct date. But the Last
>>>>>>transaction log backup shows as a month ago. When I
>>>>look
>>>>>>at the SQL Server Agent|Jobs it shows the[/color]
Transaction
>>>>Log
>>>>>>Job as successful. However if I look at the View Job
>>>>>>History it shows all as taking only 2 seconds. If I
>>>>show
>>>>>>step details the only thing it has listed is Check
>>Date
>>>>>>and Index Linkage and then deleting old report.
Except
>>>>for
>>>>>>the time of the last backup, the Transaction Log has
>>the
>>>>>>exact time as the Full Backup? Not sure if this was
>>set
>>>>>>up different a month ago? But do I need to create a
>>>>>>separate Maintenance Plan for Full Backups and
>>>>Transaction
>>>>>>Log Backups?
>>>>>>
>>>>>>thanks
>>>>>>george
>>>>>
>>>>>.
>>>>>
>>>
>>>.
>>>
>
>.
>
|
|
|
|
|