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?
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
Where is localdb stored?
Why the trigger fires multiple times in single login?
What are clustered and non-clustered index?
What is the difference between TRUNCATE and DROP?
Data table as parameter in sql server?
write an SQL query to list the employees who joined in the month of January?
What is a heap?
Which data type columns are the best candidates for full-text indexing?
Explain what is dbcc?
What is a database table?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
What are the options which must be set to allow the usage of optimistic models?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
What is "scheduled jobs" or "scheduled tasks"?
Explain various data region available in ssrs with their use?