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?
- 2 Answers
- 9215 Views
- IBM, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
How to create function without parameter in sql server?
What is row_number function?
Do you know what are the restrictions that views have to follow?
How to insert a new row into a table with "insert into" statements in ms sql server?
Why does sql studio use a single registered database repository? : sql server management studio
What is tablesample?
When you should use a low fill factor?
How to retrieve error messages using mssql_get_last_message()?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
Different types of keys in SQL?
Tell me what do you understand by a view? What does the with check option clause for a view do?
Explain about analysis services?
How to use old values to define new values in update statements in ms sql server?
what is create database syntax? : Sql server database administration
What are system databases into sql server (2005/2008) : sql server database administration
