Posted by kmounkhaty@yahoo.com on 12/20/05 04:12

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]