Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2014
    Posts
    42
    Provided Answers: 1

    Unanswered: Restore a Table for a database

    Hi,

    In one of the user define DB in DEVELOPMENT Env, one table got deleted by a developer , and now he is requesting to restore the table back again .

    In production the table is available with a row count of 1 Lak records,

    Could any help me what to do in this scenario.

    Is it possible to refresh the old backup from the development env on the development or do i need to refresh that particular table by copying it from PROD to DEV .

    Please assist me

  2. #2
    Join Date
    Jan 2012
    Location
    Lisbon
    Posts
    115
    Provided Answers: 1
    Hi,

    Normally a DEV table does not have to have "current" or all data. Just ddl and some data.
    So it depends of what you/customer want. Is the table in PRD too big?
    Is nice to have the same records that you had before the drop?
    Can you just get fraction of PRD rows?

    Well either way you can create the table on DEV again. Use the Prod table to recreate it on DEV.

    Then you see what options you have to populate it.

  3. #3
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Do you have a backup of dev? Depending on how you took the backup you might be able to mount the database dump as an archive DB and then copy the table data from it, else bcp from prod to dev.

  4. #4
    Join Date
    Feb 2014
    Posts
    42
    Provided Answers: 1
    actually , the developers dont want the data from prod , they are asking to restore the same table as before in dev env .

    is it possible if i do a refresh of yesterday dump today and it will work

  5. #5
    Join Date
    Feb 2014
    Posts
    42
    Provided Answers: 1
    yes i have the last 7 days of ARSystem.db.130414010001.gz dump file in .gz file , if a do a refresh using this file , will it works

Posting Permissions

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