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 is the difference between writing data to mirrored drives versus raid5 drives

903

What is the New in SQL server 2008?

950

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1058

What does it mean to normalize a database and why would you do it?

967

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

1080

Tell me about builtinadministrator?

981

What is ms sql server triggers?

990

Can you explain important index characteristics?

973

Write down the syntax and an example for create, rename and delete index?

960

Explain about merge replications?

995

What is the maximum row of a size?

999

What is difference between delete and truncate commands?

1060

How do you implement session management in SQL Server mode?

1072

What is nonclustered index with included columns ?

946

How to write a query with a right outer join in ms sql server?

897