Select redo_start_lsn from sys.master_files where database_id = db

How to check what was the last restore transaction LSN on
Log-Shipping and Mirroring when we doesn't have a Monitor
server and Witness server?

Question Posted / narasimha

Answer Posted / narasimha

Select redo_start_lsn from sys.master_files where
database_id = db_id('SecondaryDatabaseName') and type = 0

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are xml indexes?

894

What do you do in data exploration

929

What action plan is preferred if sql server is not responding?

1037

Write a sql query to delete duplicate records from a table called table1

975

What are the two modes of authentication in sql server?

982

Tell me what is the stuff and how does it differ from the replace function?

935

How to connect to a sql server using odbc_connect()?

1096

What are cursors stored procedures and triggers?

938

What is the difference between sdf and mdf?

1234

What is a result set object returned by mssql_query()?

1078

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

913

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1325

What is the distinction amongst delete and truncate?

1003

What is difference between count (*) and count column?

841

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

971