Lost Data

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,

.

Relevant Pages

  • Re: sql developer needing advice from sql server (6.5) admin guys
    ... Restore was no trivial process in the old architecture. ... are that you first need to create the database, ... Tibor Karaszi, SQL Server MVP ... When I look into the backup file the first word is 'TAPE' then the ...
    (microsoft.public.sqlserver.server)
  • Re: how to restore from file
    ... schedule and it emails daily that the backup completed successfully so I ... RESTORE DATABASE is terminating abnormally. ... > After that you can use any database name to restore the backup file. ...
    (microsoft.public.sqlserver.server)
  • RE: rookie restore and backup question(s)
    ... For important databases I will restore every backup - for others usually at ... And apparently the backup file was corrupt. ... > really want to know if that database was broken before we got there. ...
    (microsoft.public.sqlserver.server)
  • Lost Data
    ... Copy Saturday 4PM backup file to the server and do restore and do ... This database is in full mode and I do log backup every hour. ... I still had Sturday backup file, howe can I recover the 17th data? ...
    (microsoft.public.sqlserver.setup)
  • Re: Backend Exchange migrate to New Hardware (Server)
    ... Exchange mailbox stores and Exchange public folder stores. ... When you use Backup to restore Exchange databases, ... Storage Engine to restore Exchange database files and their ...
    (microsoft.public.exchange.setup)
Loading