Hello:
I am troubleshooting an application issue which uses SQL. The vendor has
asked me to provide him with the SQL transaction logs. I have no idea how
to get that information. Can anyone offer some advice on this?
Harrison Midkiff
Harrison
Does the vendor want to read the data from LOG ?
Take a look at third party product
http://www.lumigent.com/
"Harrison Midkiff" <HMidkiff@.aviinc.com> wrote in message
news:OQBiK2yMHHA.4712@.TK2MSFTNGP04.phx.gbl...
> Hello:
> I am troubleshooting an application issue which uses SQL. The vendor has
> asked me to provide him with the SQL transaction logs. I have no idea
> how to get that information. Can anyone offer some advice on this?
> Harrison Midkiff
>
|||Make sure he wants T-logs, not SQL Errorlogs. Most of the time, supoprt
folks want either the ERRORLOGs or the whole database. Rarely the t-log by
itself
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u5KXT7yMHHA.4712@.TK2MSFTNGP04.phx.gbl...
> Harrison
> Does the vendor want to read the data from LOG ?
> Take a look at third party product
> http://www.lumigent.com/
>
>
>
> "Harrison Midkiff" <HMidkiff@.aviinc.com> wrote in message
> news:OQBiK2yMHHA.4712@.TK2MSFTNGP04.phx.gbl...
>
sql
Showing posts with label logs. Show all posts
Showing posts with label logs. Show all posts
Wednesday, March 28, 2012
Need the logs...
Labels:
application,
database,
hasasked,
helloi,
idea,
logs,
microsoft,
mysql,
oracle,
provide,
server,
sql,
transaction,
troubleshooting,
vendor
Need the logs...
Hello:
I am troubleshooting an application issue which uses SQL. The vendor has
asked me to provide him with the SQL transaction logs. I have no idea how
to get that information. Can anyone offer some advice on this?
Harrison MidkiffHarrison
Does the vendor want to read the data from LOG ?
Take a look at third party product
http://www.lumigent.com/
"Harrison Midkiff" <HMidkiff@.aviinc.com> wrote in message
news:OQBiK2yMHHA.4712@.TK2MSFTNGP04.phx.gbl...
> Hello:
> I am troubleshooting an application issue which uses SQL. The vendor has
> asked me to provide him with the SQL transaction logs. I have no idea
> how to get that information. Can anyone offer some advice on this?
> Harrison Midkiff
>|||Make sure he wants T-logs, not SQL Errorlogs. Most of the time, supoprt
folks want either the ERRORLOGs or the whole database. Rarely the t-log by
itself
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u5KXT7yMHHA.4712@.TK2MSFTNGP04.phx.gbl...
> Harrison
> Does the vendor want to read the data from LOG ?
> Take a look at third party product
> http://www.lumigent.com/
>
>
>
> "Harrison Midkiff" <HMidkiff@.aviinc.com> wrote in message
> news:OQBiK2yMHHA.4712@.TK2MSFTNGP04.phx.gbl...
>
I am troubleshooting an application issue which uses SQL. The vendor has
asked me to provide him with the SQL transaction logs. I have no idea how
to get that information. Can anyone offer some advice on this?
Harrison MidkiffHarrison
Does the vendor want to read the data from LOG ?
Take a look at third party product
http://www.lumigent.com/
"Harrison Midkiff" <HMidkiff@.aviinc.com> wrote in message
news:OQBiK2yMHHA.4712@.TK2MSFTNGP04.phx.gbl...
> Hello:
> I am troubleshooting an application issue which uses SQL. The vendor has
> asked me to provide him with the SQL transaction logs. I have no idea
> how to get that information. Can anyone offer some advice on this?
> Harrison Midkiff
>|||Make sure he wants T-logs, not SQL Errorlogs. Most of the time, supoprt
folks want either the ERRORLOGs or the whole database. Rarely the t-log by
itself
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u5KXT7yMHHA.4712@.TK2MSFTNGP04.phx.gbl...
> Harrison
> Does the vendor want to read the data from LOG ?
> Take a look at third party product
> http://www.lumigent.com/
>
>
>
> "Harrison Midkiff" <HMidkiff@.aviinc.com> wrote in message
> news:OQBiK2yMHHA.4712@.TK2MSFTNGP04.phx.gbl...
>
Labels:
application,
database,
hasasked,
helloi,
idea,
logs,
microsoft,
mysql,
oracle,
provide,
server,
sql,
transaction,
troubleshooting,
vendor
Need the logs...
Hello:
I am troubleshooting an application issue which uses SQL. The vendor has
asked me to provide him with the SQL transaction logs. I have no idea how
to get that information. Can anyone offer some advice on this?
Harrison MidkiffHarrison
Does the vendor want to read the data from LOG ?
Take a look at third party product
http://www.lumigent.com/
"Harrison Midkiff" <HMidkiff@.aviinc.com> wrote in message
news:OQBiK2yMHHA.4712@.TK2MSFTNGP04.phx.gbl...
> Hello:
> I am troubleshooting an application issue which uses SQL. The vendor has
> asked me to provide him with the SQL transaction logs. I have no idea
> how to get that information. Can anyone offer some advice on this?
> Harrison Midkiff
>|||Make sure he wants T-logs, not SQL Errorlogs. Most of the time, supoprt
folks want either the ERRORLOGs or the whole database. Rarely the t-log by
itself
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u5KXT7yMHHA.4712@.TK2MSFTNGP04.phx.gbl...
> Harrison
> Does the vendor want to read the data from LOG ?
> Take a look at third party product
> http://www.lumigent.com/
>
>
>
> "Harrison Midkiff" <HMidkiff@.aviinc.com> wrote in message
> news:OQBiK2yMHHA.4712@.TK2MSFTNGP04.phx.gbl...
>> Hello:
>> I am troubleshooting an application issue which uses SQL. The vendor has
>> asked me to provide him with the SQL transaction logs. I have no idea
>> how to get that information. Can anyone offer some advice on this?
>> Harrison Midkiff
>
I am troubleshooting an application issue which uses SQL. The vendor has
asked me to provide him with the SQL transaction logs. I have no idea how
to get that information. Can anyone offer some advice on this?
Harrison MidkiffHarrison
Does the vendor want to read the data from LOG ?
Take a look at third party product
http://www.lumigent.com/
"Harrison Midkiff" <HMidkiff@.aviinc.com> wrote in message
news:OQBiK2yMHHA.4712@.TK2MSFTNGP04.phx.gbl...
> Hello:
> I am troubleshooting an application issue which uses SQL. The vendor has
> asked me to provide him with the SQL transaction logs. I have no idea
> how to get that information. Can anyone offer some advice on this?
> Harrison Midkiff
>|||Make sure he wants T-logs, not SQL Errorlogs. Most of the time, supoprt
folks want either the ERRORLOGs or the whole database. Rarely the t-log by
itself
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u5KXT7yMHHA.4712@.TK2MSFTNGP04.phx.gbl...
> Harrison
> Does the vendor want to read the data from LOG ?
> Take a look at third party product
> http://www.lumigent.com/
>
>
>
> "Harrison Midkiff" <HMidkiff@.aviinc.com> wrote in message
> news:OQBiK2yMHHA.4712@.TK2MSFTNGP04.phx.gbl...
>> Hello:
>> I am troubleshooting an application issue which uses SQL. The vendor has
>> asked me to provide him with the SQL transaction logs. I have no idea
>> how to get that information. Can anyone offer some advice on this?
>> Harrison Midkiff
>
Labels:
application,
database,
idea,
logs,
microsoft,
mysql,
oracle,
provide,
server,
sql,
transaction,
troubleshooting,
vendor
Saturday, February 25, 2012
NEED HELP! SQL Server 2000-Agent Jobs Scheduling error
I've got a SQL Server 2000 SP-4 install that is giving me an error on a job
scheduled to run 1/week on Tuesday From 8:30AM - 11:30PM. It logs this erro
r
in the error log: [192] Date calculation spin detected for Schedule 18 a
nd
does not calculate the next time the job should start.
I read an associated article at msdn that stated this error was fixed in
SP-1, which I didn't install. As mentioned before, I do have Service Pack 4
installed which should also have corrected this issue, but regardless I am
still getting it. Has anyone had this problem and found a solution? Is
there possibly a hotfix I could apply instead of having to try re-installing
SP-4? Any help would be greatly appreciated!Hi Stephen,
Welcome to use MSDN Managed Newsgroup Support.
Yes, it is a known issue in SQL Server 2000 and SQL Server 7.0. To resolve
this issue, please following this article:
FIX: SQLAgent Job with Recurring Schedule is Disabled Upon Completion of
the Schedule for the Day
http://support.microsoft.com/defaul...kb;EN-US;295378
Please try to reinstall SQL 2000 SP4.
Hopw this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.
scheduled to run 1/week on Tuesday From 8:30AM - 11:30PM. It logs this erro
r
in the error log: [192] Date calculation spin detected for Schedule 18 a
nd
does not calculate the next time the job should start.
I read an associated article at msdn that stated this error was fixed in
SP-1, which I didn't install. As mentioned before, I do have Service Pack 4
installed which should also have corrected this issue, but regardless I am
still getting it. Has anyone had this problem and found a solution? Is
there possibly a hotfix I could apply instead of having to try re-installing
SP-4? Any help would be greatly appreciated!Hi Stephen,
Welcome to use MSDN Managed Newsgroup Support.
Yes, it is a known issue in SQL Server 2000 and SQL Server 7.0. To resolve
this issue, please following this article:
FIX: SQLAgent Job with Recurring Schedule is Disabled Upon Completion of
the Schedule for the Day
http://support.microsoft.com/defaul...kb;EN-US;295378
Please try to reinstall SQL 2000 SP4.
Hopw this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.
NEED HELP! SQL Server 2000-Agent Jobs Scheduling error
I've got a SQL Server 2000 SP-4 install that is giving me an error on a job
scheduled to run 1/week on Tuesday From 8:30AM - 11:30PM. It logs this error
in the error log: [192] Date calculation spin detected for Schedule 18 and
does not calculate the next time the job should start.
I read an associated article at msdn that stated this error was fixed in
SP-1, which I didn't install. As mentioned before, I do have Service Pack 4
installed which should also have corrected this issue, but regardless I am
still getting it. Has anyone had this problem and found a solution? Is
there possibly a hotfix I could apply instead of having to try re-installing
SP-4? Any help would be greatly appreciated!
Hi Stephen,
Welcome to use MSDN Managed Newsgroup Support.
Yes, it is a known issue in SQL Server 2000 and SQL Server 7.0. To resolve
this issue, please following this article:
FIX: SQLAgent Job with Recurring Schedule is Disabled Upon Completion of
the Schedule for the Day
http://support.microsoft.com/default...b;EN-US;295378
Please try to reinstall SQL 2000 SP4.
Hopw this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
scheduled to run 1/week on Tuesday From 8:30AM - 11:30PM. It logs this error
in the error log: [192] Date calculation spin detected for Schedule 18 and
does not calculate the next time the job should start.
I read an associated article at msdn that stated this error was fixed in
SP-1, which I didn't install. As mentioned before, I do have Service Pack 4
installed which should also have corrected this issue, but regardless I am
still getting it. Has anyone had this problem and found a solution? Is
there possibly a hotfix I could apply instead of having to try re-installing
SP-4? Any help would be greatly appreciated!
Hi Stephen,
Welcome to use MSDN Managed Newsgroup Support.
Yes, it is a known issue in SQL Server 2000 and SQL Server 7.0. To resolve
this issue, please following this article:
FIX: SQLAgent Job with Recurring Schedule is Disabled Upon Completion of
the Schedule for the Day
http://support.microsoft.com/default...b;EN-US;295378
Please try to reinstall SQL 2000 SP4.
Hopw this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
NEED HELP! SQL Server 2000-Agent Jobs Scheduling error
I've got a SQL Server 2000 SP-4 install that is giving me an error on a job
scheduled to run 1/week on Tuesday From 8:30AM - 11:30PM. It logs this error
in the error log: [192] Date calculation spin detected for Schedule 18 and
does not calculate the next time the job should start.
I read an associated article at msdn that stated this error was fixed in
SP-1, which I didn't install. As mentioned before, I do have Service Pack 4
installed which should also have corrected this issue, but regardless I am
still getting it. Has anyone had this problem and found a solution? Is
there possibly a hotfix I could apply instead of having to try re-installing
SP-4? Any help would be greatly appreciated!Hi Stephen,
Welcome to use MSDN Managed Newsgroup Support.
Yes, it is a known issue in SQL Server 2000 and SQL Server 7.0. To resolve
this issue, please following this article:
FIX: SQLAgent Job with Recurring Schedule is Disabled Upon Completion of
the Schedule for the Day
http://support.microsoft.com/default.aspx?scid=kb;EN-US;295378
Please try to reinstall SQL 2000 SP4.
Hopw this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
scheduled to run 1/week on Tuesday From 8:30AM - 11:30PM. It logs this error
in the error log: [192] Date calculation spin detected for Schedule 18 and
does not calculate the next time the job should start.
I read an associated article at msdn that stated this error was fixed in
SP-1, which I didn't install. As mentioned before, I do have Service Pack 4
installed which should also have corrected this issue, but regardless I am
still getting it. Has anyone had this problem and found a solution? Is
there possibly a hotfix I could apply instead of having to try re-installing
SP-4? Any help would be greatly appreciated!Hi Stephen,
Welcome to use MSDN Managed Newsgroup Support.
Yes, it is a known issue in SQL Server 2000 and SQL Server 7.0. To resolve
this issue, please following this article:
FIX: SQLAgent Job with Recurring Schedule is Disabled Upon Completion of
the Schedule for the Day
http://support.microsoft.com/default.aspx?scid=kb;EN-US;295378
Please try to reinstall SQL 2000 SP4.
Hopw this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Posts (Atom)