Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Posts
    55

    Question Unanswered: Retrieveing objects

    Dears,
    I created a table, then dropped it by mistake. Is there any way to retrieve it back using the log file? The lat DB backup was made before creating the table.

    Thanks,

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    1. Take a log backup
    2. make another database and restore the previous full backup over there as you would not want to make any changes to the original db
    3. restore transaction log to a time before you dropped the table
    4. copy table onto original database

    tell me if you need any other help

  3. #3
    Join Date
    Jul 2003
    Posts
    55
    When applying the backup, through the Enterprise Manager, I had the "Point in time restore" option disabled. Have an idea why? Do you think making the backup through the T-SQL better?


    Originally posted by Enigma
    1. Take a log backup
    2. make another database and restore the previous full backup over there as you would not want to make any changes to the original db
    3. restore transaction log to a time before you dropped the table
    4. copy table onto original database

    tell me if you need any other help

  4. #4
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Question : What is your database recovery model

    Simple , Full or Bulk Logged

    Give me a list of the things you have done till now ....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •