SQL View to Return the Last Restore Date of Microsoft SQL Server Databases

This script will create a SQL view to select the last restore date for every database on a Microsoft SQL Server along with the user who performed the restore.

It has included a couple of other use columns in the returned data such as the collation_name and compatibility_level:

-- drop view if it exists
IF OBJECT_ID(N'uv_AZRCRVGetLastDatabaseRestoreDate', N'V') IS NOT NULL
    DROP VIEW...

Continue Reading Ian Grieve’s Article on their blog

SQL View to Return the Last Restore Date of Microsoft SQL Server Databases

This script will create a SQL view to select the last restore date for every database on a Microsoft SQL Server along with the user who performed the restore. It has included a couple of other use‎…

Blog Syndicated with Ian Grieve’s Permission