which transaction log was applied last?
in [Using MS SQL Server]
|
Prev: Whitepaper - Spreadsheet reporting within a BI framework
Next: URGENT! PLS HELP - Production problem
From: Ultrak The DBA on 9 Jul 2010 10:50 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.
From: Ultrak The DBA on 9 Jul 2010 13:18 On Jul 9, 10:50 am, Ultrak The DBA <truthinl...(a)yahoo.com> wrote: > 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. I know db2 has a command "db2 rollforward db dbxxxx query status" that provides this information.
From: Erland Sommarskog on 9 Jul 2010 15:48 Ultrak The DBA (truthinlife(a)yahoo.com) writes: > On Jul 9, 10:50�am, Ultrak The DBA <truthinl...(a)yahoo.com> wrote: >> 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? >> > I know db2 has a command "db2 rollforward db dbxxxx query status" > that provides this information. 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(a)sommarskog.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/prodinfo/previousversions/books.mspx
From: Ultrak The DBA on 9 Jul 2010 16:51 On Jul 9, 3:48 pm, Erland Sommarskog <esq...(a)sommarskog.se> wrote: > Ultrak The DBA (truthinl...(a)yahoo.com) writes: > > > On Jul 9, 10:50 am, Ultrak The DBA <truthinl...(a)yahoo.com> wrote: > >> 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? > > > I know db2 has a command "db2 rollforward db dbxxxx query status" > > that provides this information. > > 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, esq...(a)sommarskog.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/prodinfo/previousversions/books.mspx 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.
From: Erland Sommarskog on 9 Jul 2010 17:58
Ultrak The DBA (truthinlife(a)yahoo.com) writes: > 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. 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(a)sommarskog.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/prodinfo/previousversions/books.mspx |