home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 17,831 of 19,505   
   Erland Sommarskog to Ultrak The DBA   
   Re: which transaction log was applied la   
   09 Jul 10 21:48:40   
   
   8fd5f2e9   
   From: esquel@sommarskog.se   
      
   Ultrak The DBA (truthinlife@yahoo.com) writes:   
   > On Jul 9, 10:50 am, Ultrak The DBA  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@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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca