Tuesday, 25 December 2012

Get SQL Server Restore history using T-SQL?

SELECT *
FROM MSDB..RestoreHistory WITH (nolock)
WHERE destination_database_name = 'MyDB'
ORDER BY restore_date DESC

No comments:

Post a Comment

Table Partitioning in SQL Server

  Table Partitioning in SQL Server – Step by Step Partitioning in SQL Server task is divided into four steps: Create a File Group Add Files ...