Hi All,

I have a few SQL 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.
- Aravin

On Jan 31, 11:01 pm, "Query Builder" <querybuil... (AT) gmail (DOT) com> wrote:

Which DBMS product?
Which Version?

We aren't mind readers. There are hundreds of DBMS products, old and
new, current and obsolete. We have no idea which one you mean.

ed

On Jan 31, 10:01 pm, "Query Builder" <querybuil... (AT) gmail (DOT) com> wrote:
The file system should give you the last date of modification of your
backup files. You should use that instead of trying to figure it out
from the data in the backup.

On 2 Feb 2007 08:29:12 -0800, "eKo1" <berndlosert (AT) netscape (DOT) net> wrote:

Since the files have been removed from the volume on which they
originally resided, I suspect the file datestamp is unreliable.

As Ed said, if we know the DBMS in use we might be able to help a bit
better.

Lemming
--
Curiosity *may* have killed Schrodinger's cat.

Sorry for the missing info.. Its SQL Server 2000 with SP4.

Thanks...

On Feb 4, 6:20 pm, Lemming <thiswillbou... (AT) bumblbee (DOT) demon.co.uk>
wrote:

On 7 Feb 2007 08:37:46 -0800, "Query Builder" <querybuilder (AT) gmail (DOT) com>
wrote:

MS SQL? Sorry, then you are screwed.

And please don't top-post.

Lemming
--
Curiosity *may* have killed Schrodinger's cat.