Posted by Erland Sommarskog on 02/01/07 23:13

Query Builder (querybuilder@gmail.com) writes:
> I have to a few backups restored from a set of backup files. The
> backup files have been removed from the drive because of some storage
> constrains...
>
> For some data comparison reasons, I need to figure out the actual date
> of these backup files that is used to restore these databases. Is
> there any system table I can query to figure the actual backup times
> of these databases...
>
> Any help will be much appreciated.. Thanks in advance.

If the backups were taken on the same server, you may be able to dig
this out from the tables in msdb. You would have to start with
restorehistory and go backwards from there. I'm offering a query,
because I have worked very little with these tables myself. But they
are documented in Books Online, althoughly fairly briefly.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: SQL Server 2005 order by date does not sort properly
• Prev in forum: Re: Why transaction gets promoted to Distributed transaction
• Thread view: Re: How do I determine the backup date of a restored Database..?

[Reply to this message]