Viewing 15 posts - 1 through 15 (of 137 total)
Yeah probably what I wrote and what I meant might have come across a little grey. I pretty much wanted a Prod Restore on the UAT Server, but keeping both...
December 20, 2018 at 3:14 pm
FYI, I've resolved the issue. I created it going down the path of using Elastic Query. it was a little bit clunky (in preview mode) but achieved the results.
December 19, 2018 at 10:45 pm
Thanks for the reply, not sure If i misunderstood your answer or didn't explain properly.
Below action Plan:
1. Copy a production backup and restore...
December 19, 2018 at 4:12 pm
forgot to add - will be using PowerShell to automate all this. I can manually create a script and call it but it will need to be maintained which defeats...
December 18, 2018 at 8:42 pm
January 5, 2018 at 4:58 am
January 5, 2018 at 2:46 am
They will be production backups and configurations will vary. E.g Simple recovery model will be in SYSTEST/UAT while PROD will have FULL.
Datavolume and transaction counts will obviously reduce...
December 27, 2017 at 8:21 pm
April 29, 2017 at 12:29 am
I've read a few articles, some good some bad.
I think i understand but still little confused on setup. I'll definitely run a test, need a bit of hands on...
December 7, 2016 at 4:41 am
Sorry if im misunderstanding... so this setup would work?
Original country 1 - host database and no changes, read/write etc
New Country 2 - has a copy of country 1s Db...
December 7, 2016 at 4:28 am
Correct me if I'm wrong, but merge replication from what ive read will resolve the conflicts in IDs etc... but the read process, they will still have to query...
December 7, 2016 at 3:45 am
Thanks for the quick reply. I haven't looked at merge replication as I'm very green in this type of area (rep, mirroring etc).
I'll have a read of it now...
December 7, 2016 at 3:36 am
Unfortunately i can't do the approach of restoring a backup on to another env.
Is it not better to do both physical and logical? If you had too choose would you...
October 6, 2016 at 3:12 am
October 5, 2016 at 3:13 pm
Eric M Russell (8/23/2016)
Unit Testing a stored procedure, generally speaking, is when you execute a...
August 23, 2016 at 8:25 pm