Check out the output from LOAD HEADERONLY <backupdevice>.
It has all the info you need (the timestamp has to follow each other,
MCDBA, MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Please reply to the newsgroup only, not by email.
> I'm using 6.5. I read that kb article. Does it apply to 6.5 as well?
> > There is an old explanation at Article ID: Q95867 in the KB. What
> > of SQL are you currently using/
> > HTH
> > Jerry
> > >Can anyone give me a good explanation (or point me to where I can
> > >one) of how restores and current time stamps work? I find it very
> > >confusing when I do a transaction log restore and get error 4305,
> > >"Specified file is out of sequence. Current time stamp is <datetime>
> > >while dump was from <datetime>."
> > >Thanks
> > >Sent via Deja.com http://www.deja.com/
> > >Before you buy.
> Sent via Deja.com http://www.deja.com/
> Before you buy.