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

Tell me what is normalization? Explain different forms of normalization?

1030

How to convert a numeric expression from one data type to another?

1016

How can we improve performance by using SQL Server profiler?

1055

Can a table be moved to different filegroup?

976

Explain the truncate command?

987

What is log cache in sql server?

1046

Explain stored procedure?

1055

What do you mean by stored techniques? How would we use it?

1035

Can group by and orderby be used together?

1015

What is a cube? : sql server analysis services, ssas

999

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1078

What are the new features of sql server 2012 reporting service?

133

What happens when converting big values to integers?

999

Explain what are the events recorded in a transaction log?

1006

What is row_number () and partition by in sql server?

1080