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.
Blog Syndicated with Ian Grieve’s Permission
More About This Author
Array
Dyn365GP24 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete an Environment
Dyn365GP23 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete a Company
Dyn365GP22 April 2024Upcoming Microsoft Dynamics 365 Business Central Knowledge Hub Webinars (May-Jul 2024) from MADIC dynamics
Dyn365GP22 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Rename an Environment
