Posted by Steve on 10/11/06 14:51

jamesd wrote:
> Say I have 3 .bak files named:
>
> jamesB.bak, jamesG.bak, jamesW.bak
>
> Is there a clever way to find out which is the most recent of these
> backup files?? Using sql query analyzer preferably...

USE msdb;
GO
SELECT * FROM dbo.backupset;



SELECT * FROM dbo.backupfile;
SELECT * FROM dbo.backupfilegroup;
SELECT * FROM dbo.backupmediafamily;
SELECT * FROM dbo.backupmediaset;

• Next in forum: Re: Double summation
• Prev in forum: Query Assistance Needed - Please
• Thread view: Re: clever date to find most recent .bak file

[Reply to this message]