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

Do you know what are acid properties of transaction?

0 Answers  

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

0 Answers  

What is built-in function?

0 Answers  

How to execute stored procedure in select statement sql server?

0 Answers  

What is xml datatype?

0 Answers  




What is the difference between varchar and nvarchar?

0 Answers  

Where in ms sql server is ’100’ equal to ‘0’?

0 Answers  

Explain the commands in sql server?

0 Answers  

Differentiate between a local and a global temporary table?

0 Answers  

Where is trigger in sql server?

0 Answers  

What is use of except clause? How does it differ from not in clause?

0 Answers  

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

For more SQL Server Interview Questions Click Here
Categories