Lost Data

• Attopeu

  Ten Centuries

  Points: 1308

  More actions

  December 19, 2005 at 6:33 pm

  #110503

  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,

• Lowell

  SSC Guru

  Points: 323518

  More actions

  December 21, 2005 at 6:10 am

  #610806

  when you did the manual backup on Saturday 4pm, could it be that the backup was set to the default of "append to existing media"?

  in that case, the backup file can contain multiple backups, and it will by default restore the oldest/first in the backup file unless you explicitly select the right one.

  when you restore, in enterprise manager you need to click on the button "View Contents" button, which will open a window showing all full backups in the backup file. select the last one instead of the first one and restore.

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!