Help!!

• fftt

  Newbie

  Points: 1

  More actions

  April 3, 2003 at 12:13 pm

  #151812

  Hi,

  I drop a table in sql7.

  How i can restore this table.The big problem

  is that not exist any previous backup.

  Can I use the transaction log for this problem.

  thanks for your help.

  fernando tapia

  
  fernando tapia

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  April 3, 2003 at 12:23 pm

  #453084

  If you don't have a backup you can't restore the table. You should be carefull and always have a backup of your databases.

  You can use a third party tool like Lumigent Log Explorer. Check http://www.lumigent.com.

  With this you can check the log and undo any mistakes you have done.

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  April 3, 2003 at 12:39 pm

  #453089

  If you have an old full backup of the database prior to creating the table, then you should be able to do the following:

  1) Backup the transaction log.

  2) Backup the database, just in case you need to recovery other stuff

  3) Restore from the full backup with norecovery.

  4) Restore the transaction log using the STOPAT parm to stop the restore just prior to the time the table was delete.

  Gregory Larsen, DBA

  If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP