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 trigger explain with program?

1019

How to enter comments in transact-sql statements?

989

How to connect a database with sql express.?

1120

How do I manually uninstall an instance of sql server 2016?

1082

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1116

How do I find the default sql server instance?

990

How to update values in a table with update statements in ms sql server?

1066

What is bulkcopy in sql?

1000

How to recreate an existing index in ms sql server?

1119

Where views are stored in sql server?

1036

How to create a simple table to test triggers in ms sql server?

1038

How to execute stored procedure in select statement sql server?

1114

Explain about system database?

1110

What is a natural primary key?

1111

Explain the phases a transaction has to undergo?

1115