Saturday, April 16, 2011

Restore history Details for sql databases.....

How do we find restore history details for all databases in the server?
Or single database?

—-for all databases
USE MSDB

GO

SELECT TOP 1 *

FROM RESTOREHISTORY WITH (nolock)
--for individual database include below commands

WHERE (DESTINATION_DATABASE_NAME = ‘dbname’)

ORDER BY RESTORE_DATE DESC

Let me know any other ways?

No comments:

Post a Comment

MYSQL:::Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables

  Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables Introduction: In the dynamic landscape of database management...