Event 208 Error

Good Morning!
I'm new to SQL so I thank you for your patience. I get an
Event 208 error that says the following:
SQL Server Scheduled Job! Transaction Log Backup Job for
DB Maintenance 'DB Maintenance Plan1'
ox153E93B174EA8E4AAF3C52AD7DD8480D) Status failed-Invoked
on 4/19/04 12:10 am Message: The Job failed. The job was
invoked by Schedule 2 (Schedule1) The last step to run was
step1(step1).
I don't know if i misconfigured the backup/tranaction
maintenance plan. I have the completed backup run daily
at 2am and removes files older than 4 days. I have the
transaction run daily at 12:10am and removes files older
than 4 days.
I appreciated any help you can give me with fixing this
error. Thanks.Look at the maintenance plan history (not the SQL agent job history). Drill
to Database Maintanance Plans Enterprise Mangler. Right-click on the
maintenance plan name in the right pane. Choose Maintenance Plan
History... You can get details on the specific cause of the failure. I
will monitor this thread if you need further assistance.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Phoenix" <anonymous@.discussions.microsoft.com> wrote in message
news:101201c42621$5dc84a00$a501280a@.phx.gbl...
> Good Morning!
> I'm new to SQL so I thank you for your patience. I get an
> Event 208 error that says the following:
> SQL Server Scheduled Job! Transaction Log Backup Job for
> DB Maintenance 'DB Maintenance Plan1'
> ox153E93B174EA8E4AAF3C52AD7DD8480D) Status failed-Invoked
> on 4/19/04 12:10 am Message: The Job failed. The job was
> invoked by Schedule 2 (Schedule1) The last step to run was
> step1(step1).
> I don't know if i misconfigured the backup/tranaction
> maintenance plan. I have the completed backup run daily
> at 2am and removes files older than 4 days. I have the
> transaction run daily at 12:10am and removes files older
> than 4 days.
> I appreciated any help you can give me with fixing this
> error. Thanks.
>|||Geoff,
Thanks for your help. Below is what the maintenance plan
history Message says:
[Microsoft SQL-DMO (ODBC SQL State:420000] Error 4213:
[Microsoft][ODBC SQL Driver](SQL Server) cannot allow
backup log because file 'strataview_data' has been
subjected to nonlogged updates and cannot be rolled
forward. Perform a full backup, or differntial database,
backup.
[Microsoft] (ODBC SQL Server Driver)[SQL Server] Backup or
Restor operation terminating abnormally.
Honestly, Geoff I'm very new to this. I'm not sure what
this means. However, I did understand to Perform a full
Backup. What should I do to fix this problem?

>--Original Message--
>Look at the maintenance plan history (not the SQL agent
job history). Drill
>to Database Maintanance Plans Enterprise Mangler. Right-
click on the
>maintenance plan name in the right pane. Choose
Maintenance Plan
>History... You can get details on the specific cause of
the failure. I
>will monitor this thread if you need further assistance.
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"Phoenix" <anonymous@.discussions.microsoft.com> wrote in
message
>news:101201c42621$5dc84a00$a501280a@.phx.gbl...
an[vbcol=seagreen]
Invoked[vbcol=seagreen]
was[vbcol=seagreen]
was[vbcol=seagreen]
>
>.
>|||Something did a non-logged operation. Probably some type of data import
task, but that is just a guess. You will need to find out what this process
is and either fix it or adjust your backup procedures to accomodate it. You
might try Log Explorer from Lumigent (www.lumigent.com) to search the
transaction log to find out exactly what the non-logged operation is and who
did it.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Phoenix" <anonymous@.discussions.microsoft.com> wrote in message
news:11fb01c4263f$8b364000$a401280a@.phx.gbl...[vbcol=seagreen]
> Geoff,
> Thanks for your help. Below is what the maintenance plan
> history Message says:
> [Microsoft SQL-DMO (ODBC SQL State:420000] Error 4213:
> [Microsoft][ODBC SQL Driver](SQL Server) cannot allow
> backup log because file 'strataview_data' has been
> subjected to nonlogged updates and cannot be rolled
> forward. Perform a full backup, or differntial database,
> backup.
> [Microsoft] (ODBC SQL Server Driver)[SQL Server] Backup or
> Restor operation terminating abnormally.
> Honestly, Geoff I'm very new to this. I'm not sure what
> this means. However, I did understand to Perform a full
> Backup. What should I do to fix this problem?
>
> job history). Drill
> click on the
> Maintenance Plan
> the failure. I
> message
> an
> Invoked
> was
> was|||Geoff,
A data import process runs everynight at 9pm and finishes
at 10pm. I will see if I can get this Log Explorer. I'm
not sure if this Log Explorer is easy to use. But I'll
try. How would I adjust me backup procedures if the
import run between 9pm and 10pm? Because the backups run
at 2pm and transaction log at 12:10pm.
Thanks again for your help!!!
>--Original Message--
>Something did a non-logged operation. Probably some type
of data import
>task, but that is just a guess. You will need to find
out what this process
>is and either fix it or adjust your backup procedures to
accomodate it. You
>might try Log Explorer from Lumigent (www.lumigent.com)
to search the
>transaction log to find out exactly what the non-logged
operation is and who
>did it.
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"Phoenix" <anonymous@.discussions.microsoft.com> wrote in
message
>news:11fb01c4263f$8b364000$a401280a@.phx.gbl...
plan[vbcol=seagreen]
database,[vbcol=seagreen]
or[vbcol=seagreen]
Right-[vbcol=seagreen]
of[vbcol=seagreen]
assistance.[vbcol=seagreen]
in[vbcol=seagreen]
get[vbcol=seagreen]
for[vbcol=seagreen]
run[vbcol=seagreen]
daily[vbcol=seagreen]
the[vbcol=seagreen]
older[vbcol=seagreen]
this[vbcol=seagreen]
>
>.
>|||You would have to run a full backup immediately following the import task to
reset the log sequence. Either that or change the process so it doesn't
make non-logged data modifications. Log explorer is very easy to use and is
pretty useful. Ever get asked to 'undo' somebody's mistake? You will and
LE will help.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Phoenix" <anonymous@.discussions.microsoft.com> wrote in message
news:12e301c42644$828914f0$a001280a@.phx.gbl...[vbcol=seagreen]
> Geoff,
> A data import process runs everynight at 9pm and finishes
> at 10pm. I will see if I can get this Log Explorer. I'm
> not sure if this Log Explorer is easy to use. But I'll
> try. How would I adjust me backup procedures if the
> import run between 9pm and 10pm? Because the backups run
> at 2pm and transaction log at 12:10pm.
> Thanks again for your help!!!
> of data import
> out what this process
> accomodate it. You
> to search the
> operation is and who
> message
> plan
> database,
> or
> Right-
> of
> assistance.
> in
> get
> for
> run
> daily
> the
> older
> this