January 3, 2012 at 3:55 am
Temporarily data is in very less size and as of now am copying the data to QA Server according client request with simple insert into Statement.
January 3, 2012 at 3:58 am
MasterDB (1/3/2012)
Temporarily data is in very less size and as of now am copying the data to QA Server according client request with simple insert into Statement.
???
That means you'll miss any updates or deletes. Unless you're checking for existence first, you could also get duplicate rows or primary key violations.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 3, 2012 at 4:17 am
Duplicates are ok with my case and this is not Production Server. it is in DEV environment.
January 3, 2012 at 2:05 pm
If you still have
1. full backup of xyz database with which you created\restored xyz_qa on DEF instance and
2. Transaction Log backups of xyz database after that full backup till the time to which you want your restore your xyz_qa database
then do
restore full backup as mentioned in step 1 on xyz_qa on def instance with "replace" and "norecovery" option and then restore successive log backups of step 2 with "norecovery" option. once done, run "restore database xyz_qa with recovery" which will bring the database online.
The key is log backup records the changes made after the last full\log backup and restoring it will do the same changes on the destination database.
January 3, 2012 at 2:09 pm
if you want selective table data only then my way will not work since log backup has a record of all changes made to all the database object and not filtered. In that scenario seems merge is the way to go as mentioned by gail.
January 4, 2012 at 12:18 am
Thank you for your input,
In No Recovery mode i can't access the Database in QA.
Here the thing is i want to access and needs to do modifications in QA Database server.
January 4, 2012 at 2:06 am
MasterDB (1/4/2012)
Here the thing is i want to access and needs to do modifications in QA Database server.
Then you can't use backups for this, you'll have to go for scripts or some data compare tool
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 16 through 21 (of 21 total)
You must be logged in to reply to this topic. Login to reply