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

What are different types of subquery?

0 Answers  

What is query cost in sql server?

0 Answers  

What is data compression?

0 Answers  

What are the steps to process a single select statement?

0 Answers  

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,




Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

0 Answers   HP,

How to use subqueries in the from clause in ms sql server?

0 Answers  

Explain the advantages of merge replication?

0 Answers  

How to transfer an existing table from one schema to another schema in ms sql server?

0 Answers  

What is the difference between a "where" clause and a "having" clause?

0 Answers  

what is procedure in sql?

2 Answers   Millennium, SQL,

What happens if an integer is too big for int date type?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories