Getting SQL Server Last Restore history Date.

vishalneeraj-24503
Posted by vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 441
Write below query:-
SELECT RESTORE_HISTORY_ID,RESTORE_DATE,DESTINATION_DATABASE_NAME,USER_NAME
FROM MSDB..RestoreHistory WITH (nolock)
WHERE DESTINATION_DATABASE_NAME = 'YourDBName'
ORDER BY RESTORE_DATE DESC;

Comments or Responses

Login to post response