Every time job property changes

Dear friends,

Every time i open the jobs propertimes on server, it changes the sql server login to windows from sql authentication. also the properties i set at the time of creating a job had given me an option to select the run as user but from that moment the option has gone, whats that all about?

thanks,

This is a SSIS forum. Is this an SSIS related issue? otherwise, I could moved this thread to the Database Engine forum http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=93&SiteID=1|||

Thanks,

How to move this?

Rafael Salas wrote:

This is a SSIS forum. Is this an SSIS related issue? otherwise, I could moved this thread to the Database Engine forum http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=93&SiteID=1

|||

Dear Rafael Salas, can you please move this thread to the database engine forum, or else as being a simple member of msdn forums can i do this? if yes then how?

thanks,

|||

thanks, but how do i prevent those changes.

thanks,

Event Log: Log Backup Successes

Is there a way to prevent logging the sucessful SQL Server Log Backups to
the application event log? This is not success of the job (we have write to
event log on failure for the job).
We have sql servers with 70 or so different databases on them and back up
the logs every 15 minutes. Do the math. We have to keep our event logs very
large in order to retain the worthwhile information for any length of time.
Thanks!
Michelle
A common request but the answer is no. Even amending the dlevel in
sysmessages won't stop it writing to the event log. We have consolidated
servers with 8 instances and hundreds of databases and I agree it's a
complete pain in the neck :-)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"michelle" <michelle@.nospam.com> wrote in message
news:O1$BIWsCFHA.3120@.TK2MSFTNGP12.phx.gbl...
> Is there a way to prevent logging the sucessful SQL Server Log Backups to
> the application event log? This is not success of the job (we have write
> to
> event log on failure for the job).
> We have sql servers with 70 or so different databases on them and back up
> the logs every 15 minutes. Do the math. We have to keep our event logs
> very
> large in order to retain the worthwhile information for any length of
> time.
> Thanks!
> Michelle
>

Event ID 208

Hello:
Have you ever seen the following warnings in your Event Log?
SQL Server Scheduled Job 'Transactions' (0x86C147BDD7FFD611899E001083FD1071)
- Status: Failed - Invoked on: 3/25/2004 9:00:00 AM - Message: The job fail
ed. The Job was invoked by Schedule 41 (6.x schedule). The last step to ru
n was step 1 (Transactions)Go to your job, the job step. Define an output file and see what *SQL Server
* errors you get here. You might
even already have the errors in the job history table (EM, Management, Jobs,
your job, Job history, and check
"show step details" and go to the appropriate job step)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"King Buzzo" <anonymous@.discussions.microsoft.com> wrote in message
news:1A1F2443-467D-44AF-A5D7-EBF238A86982@.microsoft.com...
> Hello:
> Have you ever seen the following warnings in your Event Log?
> SQL Server Scheduled Job 'Transactions' (0x86C147BDD7FFD611899E001083FD1071) - Sta
tus: Failed - Invoked on:
3/25/2004 9:00:00 AM - Message: The job failed. The Job was invoked by Sche
dule 41 (6.x schedule). The last
step to run was step 1 (Transactions).
> I can't find anything on technet and the SQL dumps are working.
> Do I have to re-create the job?
> Thanks!

Event Id 17055 SQL Id 18265

am receiving those every 30 min for 6 table. I have multiple job and they
are all set to only notify on failure. Why Am I receiving those multiple
time a day?
Source MSSQLSERVER
Category (6)
Event Id 17055
18265 : Log backed up : Database: MyDatabase, Creation date(time): 2005/XX/XX
First LSN 8:1866:1, Last LSN 8:1866:1, number of dump device 1
Device informationFILE=1, TYPE=DISK:{'h:\XXX\XXX\XXX\XXX.trn}).
If this is part of a mantainance plan something withon the plan went wrong.
Did you try to check wheter the files are present on disk ?
http://groups.google.de/groups?q=182...oft.com&rnum=2
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"fatp" <fatp@.discussions.microsoft.com> schrieb im Newsbeitrag
news:394E31EC-F958-49CE-903A-308F608FD824@.microsoft.com...
> am receiving those every 30 min for 6 table. I have multiple job and they
> are all set to only notify on failure. Why Am I receiving those multiple
> time a day?
> Source MSSQLSERVER
> Category (6)
> Event Id 17055
> 18265 : Log backed up : Database: MyDatabase, Creation date(time):
> 2005/XX/XX
> First LSN 8:1866:1, Last LSN 8:1866:1, number of dump device 1
> Device informationFILE=1, TYPE=DISK:{'h:\XXX\XXX\XXX\XXX.trn}).

Event Id 17055 SQL Id 18265

am receiving those every 30 min for 6 table. I have multiple job and they
are all set to only notify on failure. Why Am I receiving those multiple
time a day?
Source MSSQLSERVER
Category (6)
Event Id 17055
18265 : Log backed up : Database: MyDatabase, Creation date(time): 2005/XX/X
X
First LSN 8:1866:1, Last LSN 8:1866:1, number of dump device 1
Device informationFILE=1, TYPE=DISK:{'h:\XXX\XXX\XXX\XXX.trn}).If this is part of a mantainance plan something withon the plan went wrong.
Did you try to check wheter the files are present on disk ?
9%40cppssbbsa02.microsoft.com&rnum=2" target="_blank">http://groups.google.de/groups?q=18...soft.com&rnum=2
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"fatp" <fatp@.discussions.microsoft.com> schrieb im Newsbeitrag
news:394E31EC-F958-49CE-903A-308F608FD824@.microsoft.com...
> am receiving those every 30 min for 6 table. I have multiple job and they
> are all set to only notify on failure. Why Am I receiving those multiple
> time a day?
> Source MSSQLSERVER
> Category (6)
> Event Id 17055
> 18265 : Log backed up : Database: MyDatabase, Creation date(time):
> 2005/XX/XX
> First LSN 8:1866:1, Last LSN 8:1866:1, number of dump device 1
> Device informationFILE=1, TYPE=DISK:{'h:\XXX\XXX\XXX\XXX.trn}).

Event Id 17055 SQL Id 18265

am receiving those every 30 min for 6 table. I have multiple job and they
are all set to only notify on failure. Why Am I receiving those multiple
time a day?
Source MSSQLSERVER
Category (6)
Event Id 17055
18265 : Log backed up : Database: MyDatabase, Creation date(time): 2005/XX/XX
First LSN 8:1866:1, Last LSN 8:1866:1, number of dump device 1
Device information:(FILE=1, TYPE=DISK:{'h:\XXX\XXX\XXX\XXX.trn}).If this is part of a mantainance plan something withon the plan went wrong.
Did you try to check wheter the files are present on disk ?
http://groups.google.de/groups?q=18265+log+failure&hl=de&lr=&selm=%23BvTNL6XAHA.219%40cppssbbsa02.microsoft.com&rnum=2
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"fatp" <fatp@.discussions.microsoft.com> schrieb im Newsbeitrag
news:394E31EC-F958-49CE-903A-308F608FD824@.microsoft.com...
> am receiving those every 30 min for 6 table. I have multiple job and they
> are all set to only notify on failure. Why Am I receiving those multiple
> time a day?
> Source MSSQLSERVER
> Category (6)
> Event Id 17055
> 18265 : Log backed up : Database: MyDatabase, Creation date(time):
> 2005/XX/XX
> First LSN 8:1866:1, Last LSN 8:1866:1, number of dump device 1
> Device information:(FILE=1, TYPE=DISK:{'h:\XXX\XXX\XXX\XXX.trn}).

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[vbcol=seagreen]
>news:101201c42621$5dc84a00$a501280a@.phx.gbl...
an[vbcol=seagreen]
Invoked[vbcol=seagreen]
was[vbcol=seagreen]
was
>
>.
>
|||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[vbcol=seagreen]
>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
>
>.
>
|||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

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...
>> 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.
>>
>
>.
>|||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...
> 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...
> >> 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,
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...
>> 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...
>> >> 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.
>> >>
>> >>
>> >
>> >
>> >.
>> >
>
>.
>|||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...
> 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...
> >> 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...
> >> >> 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,
I can't thank you enough for all your help and support. I
appreciate your Professionalism and Technical Expertise!!!
Also, thanks for the tip on log explorer. I have
downloaded the demo version and hope to install it
sometime this week. I will run a full backup.
Phoenix
>--Original Message--
>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...
>> 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...
>> >> 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...
>> >> >> 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.
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>.
>

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