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.
>
Showing posts with label sysdatabases. Show all posts
Showing posts with label sysdatabases. Show all posts
Saturday, February 25, 2012
database refreshed using backup restore
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.
>
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.
>
database refreshed using backup restore
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.
>
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.
>
Subscribe to:
Posts (Atom)