Posted by Dan Guzman on 12/20/05 07:01

Perhaps the backup file contains multiple backups and the first (oldest) was
restored by default. I suggest you check the backup file contents with
RESTORE HEADERONLY:

RESTORE HEADERONLY
FROM DISK='C:\Backups\MyDatabase.bak'

You can use the FILE option to restore a file other than the first:

RESTORE DATABASE MyDatabase
FROM DISK='C:\Backups\MyDatabase.bak'
WITH FILE=2, REPLACE

--
Hope this helps.

Dan Guzman
SQL Server MVP

"kmounkhaty@yahoo.com" <smounkhaty@bremer.com> wrote in message
news:1135044730.906068.283080@g44g2000cwa.googlegroups.com...
> Hi Guru,
>
>
> This weekend, I migrated SQL Server7.0 to 2000 and below is the
> scenarios:
>
>
> 1.) At exactly 4:00PM on Sturday 17th, do full backup(T-SQL) and put a
> database into single user mode.
> 2.) Copy both Saturday 4PM and Friday night full dump to the SAN.
> 3.) Delete WinNT4.0.
> 4.) Reinstall Win2003 and service pack3a.
> 5.) Copy Saturday 4PM backup file to the server and do restore and do
> user ID mapping.
>
>
> This database is in full mode and I do log backup every hour. However,
> after restoring the database, any changes after the 14th were missing.
>
>
> Now, When I restored Friday night backup, we still recovered data to
> the 16th. My question is, why the 17th 4PM backup did not copy any
> change from 15th to the 17th Saturday?
>
>
> I still had Sturday backup file, howe can I recover the 17th data? Log
> explorer or ApexSQLLog?
>
>
> Is this Disk issue?
>
>
> Thanks very much,
> Silaphet,
>

[Back to original message]