How to check what was the last restore transaction LSN on Log-Shipping and Mirr

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 / sqldba29

2 Answers
9984 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn&..

Answer / 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

How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn&..

Answer / sunil

Narasimha, Thank you So much

I will very appreciate if you will send some daily usage
SQL DBA Queries like this. My mail ID is sqldba29 @
gmail.com

Is This Answer Correct ?

0 Yes

2 No

Post New Answer

More SQL Server Interview Questions

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers RND Soft, Wipro,

What is a periodical index?

0 Answers

What are the commands used in DCL?

0 Answers

What is log ldf?

0 Answers

What is meant by indexing?

0 Answers

What are the different types of columns types constraints in the sql server?

0 Answers

How to create Clustered Primary Key to table?