Very Computer

by **o..** » Tue, 19 Oct 1999 04:00:00

Can anyone give me a good explanation (or point me to where I can find
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.

by **Jerry Spive** » Tue, 19 Oct 1999 04:00:00

There is an old explanation at Article ID: Q95867 in the KB. What version
of SQL are you currently using/

HTH

Jerry

>Can anyone give me a good explanation (or point me to where I can find
>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.

by **o..** » Wed, 20 Oct 1999 04:00:00

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
version
> of SQL are you currently using/

> HTH

> Jerry

> >Can anyone give me a good explanation (or point me to where I can
find
> >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.

by **Dan Guzma** » Wed, 20 Oct 1999 04:00:00

You'll get this error if you try to apply the transaction logs out of
sequence. After a database restore, the transaction log dumps must be
applied in the same sequence in which they were dumped. The target database
should not have the 'trunc. log on chkpt.' dboption turned on.

More information is available in the Books Online.

Hope this helps.

> Can anyone give me a good explanation (or point me to where I can find
> 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.

by **Tibor Karasz** » Thu, 21 Oct 1999 04:00:00

Check out the output from LOAD HEADERONLY <backupdevice>.
It has all the info you need (the timestamp has to follow each other,
consecutively).

--
Tibor Karaszi
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
> version
> > of SQL are you currently using/

> > HTH

> > Jerry

> > >Can anyone give me a good explanation (or point me to where I can
> find
> > >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.

Very Computer

Restores, current time stamps, etc

Restores, current time stamps, etc

Restores, current time stamps, etc

Restores, current time stamps, etc

Restores, current time stamps, etc

Restores, current time stamps, etc