Database Solutions
Friday, September 3, 2010
HOW TO FIND THE LSN OF LAST TRANSACTION LOG SUCCESSFULLY RESTORED
SELECT top 5 *
FROM msdb.dbo.backupset
WHERE database_name = 'db_name'
ORDER BY backup_set_id desc
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment