|
Posted by jamesd on 10/15/06 02:11
Please assume that all 3 files have the same ntfs modified date. I am
looking for a way to examine each .bak file to read its metadata and
see which one is most recent.
If I restore each .bak file is there a way to see the date of the
backup?
Greg D. Moore (Strider) wrote:
> "jamesd" <jamesd@ring4freedom.com> wrote in message
> news:1160592663.337156.238310@k70g2000cwa.googlegroups.com...
> > Hi Steve,
> > I don't think that will work, because I do not have the original msdb
> > database. I only have 3 .bak files (from another machine) and a virgin
> > database server (sql 2000).
> >
>
> xp_cmdshell with DIR and then read it into a table.
Navigation:
[Reply to this message]
|