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 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

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...
>

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
>

Need restore help...

Hi,
I am trying to find out where SQL Server 2000 writes
when and which last position of a transaction log was
restored. I am restoring full database backup,
differential backup and multiple transaction logs.
Full backup = 1 x week
Differential backup = 6 x week
Transaction log backup = hourly
I am restoring this to another server via SQL Server
Agent jobs. When I get the error of:
The log in this backup set begins at LSN
39300000000091600001, which is too late to apply to
the database. An earlier log backup that includes LSN
38932000000015600001 can be restored. [SQLSTATE 42000]
(Error 4305) RESTORE LOG is terminating abnormally.
[SQLSTATE 42000] (Error 3013). The step failed.
There must be a comparison going on somewhere... where
there is some value that gives the last position or
number of the last time a transaction log was restored.
I am hoping that someone from microsoft comes to my
rescue or anyone else who knows where i can find this
information. This is very valuable information that will
help in releaving this error from happening.
Please advise...
Cheers!
Brettif you do
RESTORE HEADERONLY FROM ...
you will see the first LSN and last LSN.
"Brett" <anonymous@.discussions.microsoft.com> wrote in message
news:084d01c3d6e3$30e1a3c0$a001280a@.phx.gbl...
> Hi,
> I am trying to find out where SQL Server 2000 writes
> when and which last position of a transaction log was
> restored. I am restoring full database backup,
> differential backup and multiple transaction logs.
> Full backup = 1 x week
> Differential backup = 6 x week
> Transaction log backup = hourly
> I am restoring this to another server via SQL Server
> Agent jobs. When I get the error of:
> The log in this backup set begins at LSN
> 39300000000091600001, which is too late to apply to
> the database. An earlier log backup that includes LSN
> 38932000000015600001 can be restored. [SQLSTATE 42000]
> (Error 4305) RESTORE LOG is terminating abnormally.
> [SQLSTATE 42000] (Error 3013). The step failed.
> There must be a comparison going on somewhere... where
> there is some value that gives the last position or
> number of the last time a transaction log was restored.
> I am hoping that someone from microsoft comes to my
> rescue or anyone else who knows where i can find this
> information. This is very valuable information that will
> help in releaving this error from happening.
> Please advise...
> Cheers!
> Brett
>

Need restore help...

Hi,
I am trying to find out where SQL Server 2000 writes
when and which last position of a transaction log was
restored. I am restoring full database backup,
differential backup and multiple transaction logs.
Full backup = 1 x week
Differential backup = 6 x week
Transaction log backup = hourly
I am restoring this to another server via SQL Server
Agent jobs. When I get the error of:
The log in this backup set begins at LSN
39300000000091600001, which is too late to apply to
the database. An earlier log backup that includes LSN
38932000000015600001 can be restored. [SQLSTATE 42000]
(Error 4305) RESTORE LOG is terminating abnormally.
[SQLSTATE 42000] (Error 3013). The step failed.
There must be a comparison going on somewhere... where
there is some value that gives the last position or
number of the last time a transaction log was restored.
I am hoping that someone from microsoft comes to my
rescue or anyone else who knows where i can find this
information. This is very valuable information that will
help in releaving this error from happening.
Please advise...
Cheers!
Brettif you do
RESTORE HEADERONLY FROM ...
you will see the first LSN and last LSN.
"Brett" <anonymous@.discussions.microsoft.com> wrote in message
news:084d01c3d6e3$30e1a3c0$a001280a@.phx.gbl...

quote:

---

> Hi,
> I am trying to find out where SQL Server 2000 writes
> when and which last position of a transaction log was
> restored. I am restoring full database backup,
> differential backup and multiple transaction logs.
> Full backup = 1 x week
> Differential backup = 6 x week
> Transaction log backup = hourly
> I am restoring this to another server via SQL Server
> Agent jobs. When I get the error of:
> The log in this backup set begins at LSN
> 39300000000091600001, which is too late to apply to
> the database. An earlier log backup that includes LSN
> 38932000000015600001 can be restored. [SQLSTATE 42000]
> (Error 4305) RESTORE LOG is terminating abnormally.
> [SQLSTATE 42000] (Error 3013). The step failed.
> There must be a comparison going on somewhere... where
> there is some value that gives the last position or
> number of the last time a transaction log was restored.
> I am hoping that someone from microsoft comes to my
> rescue or anyone else who knows where i can find this
> information. This is very valuable information that will
> help in releaving this error from happening.
> Please advise...
> Cheers!
> Brett
>

---