How I can restore to the certain LSN (not Point-In-Time)?

Dear Sir.
How I can restore to the certain LSN (not Point-In-Time)?
Also do you know program for viewing of Transaction Log and BackUp?
Thank you in advance.Have you taken a look at the stopatmark or stopbeforemark option in SQL2005
BOL
9ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/f7b3de5b-198d-448d-8c71-1cdd9239676c.htm)?
Linchi
"RedFox" wrote:
> Dear Sir.
> How I can restore to the certain LSN (not Point-In-Time)?
> Also do you know program for viewing of Transaction Log and BackUp?
> Thank you in advance.|||Dear Linchi Shea,
Thank you for your answer, but I have asked about CERTAIN LSN (= Log
Sequence Number) - NOT MARKED Transaction.
P.S. link is not correct.
"Linchi Shea" wrote:
> Have you taken a look at the stopatmark or stopbeforemark option in SQL2005
> BOL
> 9ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/f7b3de5b-198d-448d-8c71-1cdd9239676c.htm)?
> Linchi
> "RedFox" wrote:
> > Dear Sir.
> >
> > How I can restore to the certain LSN (not Point-In-Time)?
> > Also do you know program for viewing of Transaction Log and BackUp?
> >
> > Thank you in advance.|||The link I posted earlier is for BOL. You can also use this link to the Books
Online at the Microsoft site.
http://msdn2.microsoft.com/en-us/library/ms191459.aspx
> but I have asked about CERTAIN LSN (= Log
> Sequence Number) - NOT MARKED Transaction.
It has an option to allow you to restore to a log sequence number.
Linchi
"RedFox" wrote:
> Dear Linchi Shea,
> Thank you for your answer, but I have asked about CERTAIN LSN (= Log
> Sequence Number) - NOT MARKED Transaction.
> P.S. link is not correct.
> "Linchi Shea" wrote:
> > Have you taken a look at the stopatmark or stopbeforemark option in SQL2005
> > BOL
> > 9ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/f7b3de5b-198d-448d-8c71-1cdd9239676c.htm)?
> >
> > Linchi
> >
> > "RedFox" wrote:
> >
> > > Dear Sir.
> > >
> > > How I can restore to the certain LSN (not Point-In-Time)?
> > > Also do you know program for viewing of Transaction Log and BackUp?
> > >
> > > Thank you in advance.