November 13, 2008 at 12:08 pm
I got a change request mentioned below:
Please do not do this refresh until the week of 12/1.
Please do a DATA REFRESH ONLY of the FLB_UAT database using production data from 10/31/2008.
we take full backups every day of all the users dbs and tlog backups every two hours
So if i am ready to do a data release on 12/1 these are things i would..please correct me if i am wrong
i)take a diffrential backup
ii)drop the db
iii)i would restore a full backup from 11/30 and then the differential backup which i just took b4 dropping the db...will this solve the change request mentioned above?..plz suggest me ...thx
November 13, 2008 at 2:23 pm
I don't think so. The request wants the database restored to the way it was on 10/31. Your method will restore it to the way it was on 12/01 when you made the differential backup.
Also, restoring a backup restores everything in a database - tables, data, stored procedures, users, etc. If the request only wants data refreshed, you might consider restoring the backup to a new database, truncating the tables n the FLB_UAT database and using SSIS or DTS to copy the data into the truncated tables from the new databse.
Greg
November 13, 2008 at 3:30 pm
Greg is correct. Take a backup of FLB_UAT before you do the data refresh. You need to hold onto the 10-31 production backup and not let it get automatically deleted by your normal back routine.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply