Is there a system table or a way that allows you to check
when was the last time the database was refreshed (backup
restored) ? Sysdatabases shows the db creation date.
use msdb
go
select * from restorehistory
go
"J Reyes" <anonymous@.discussions.microsoft.com> wrote in message
news:155501c4f4d0$eb3dd750$a601280a@.phx.gbl...
> Is there a system table or a way that allows you to check
> when was the last time the database was refreshed (backup
> restored) ? Sysdatabases shows the db creation date.
>
No comments:
Post a Comment