Here is the SQL to display the last LSN applied to the database (think log-shipping)
|
1 2 3 4 5 |
SELECT redo_start_lsn FROM sys.master_files WHERE database_id = DB_ID('SecondaryDatabaseName') AND type = 0 |
Views – 2769
Here is the SQL to display the last LSN applied to the database (think log-shipping)
|
1 2 3 4 5 |
SELECT redo_start_lsn FROM sys.master_files WHERE database_id = DB_ID('SecondaryDatabaseName') AND type = 0 |
Views – 2769