1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

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

explain extended properties

0 Answers  

What are the advantages of policy management?

0 Answers  

What are the various Isolation levels?

2 Answers   HP,

What are the different normalization forms?

0 Answers  

What are the different sql server versions?

0 Answers  




if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 Answers  

What are the types of database schema? : sql server analysis services, ssas

0 Answers  

What is function of CUBE ?

0 Answers   HCL,

How to get all stored procedures in sql server?

0 Answers  

How can delete duplicate records in cte in sql server?

0 Answers  

How to modify an existing user defined function?

0 Answers  

Explain the different types of joins?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories