Lost Data

[kmounkhaty]

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,

[Dan Guzman]

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

"km********@yahoo.com" <sm********@bremer.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.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,