I have a database in read-only rollforward mode. What command or where
in SQL server studio can I find the last log applied/restored?

Thank you.

On Jul 9, 10:50*am, Ultrak The DBA <truthinl... (AT) yahoo (DOT) com> wrote:
I know db2 has a command "db2 rollforward db dbxxxx query status"
that provides this information.

Ultrak The DBA (truthinlife (AT) yahoo (DOT) com) writes:
There is not really any equivalent in SQL Server. I guess it is possible
to find out which is the most recent LSN, but for my part I am not sure
what use I would have of that information.

When it comes to such things, it can be deceivious to think in terms
of other products. Because of architectual differences what makes sense
in one product, is not very useful in another.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

On Jul 9, 3:48*pm, Erland Sommarskog <esq... (AT) sommarskog (DOT) se> wrote:
Yes, but how am I supposed to figure out the next log file to use to
rollforward and keep in read_only, particularly if two disparate dbas
are working on the db.

Ultrak The DBA (truthinlife (AT) yahoo (DOT) com) writes:
OK. There are a couple of tables in the msdb database you need to look
at, backupfile, backupfilegroup, backupmediafamily, backupmediaset
and backupset. I have not worked a lot with these, so I cannot give
any exact answer, but they are documented in Books Online.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx