Hi Grant, 

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...

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...

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...

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...

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...

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...

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...

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...

RVSC48 (10/5/2016)

---

Hi, this is an excellent article to look at regarding why checkdb takes so long. You will notice the size of the database is his #1 item.

Eric M Russell (8/23/2016)

---

It sounds like you're describing some specific implementation of unit testing within SSDT or Visual Studio.

Unit Testing a stored procedure, generally speaking, is when you execute a...

vprunic (8/22/2016)

---

When i add it to a project it works fine when its executed in 32 bit

But when I start it SQL server

Code: 0xC0209303

...

vprunic (8/19/2016)

---

Hello all,

what does this mean?

Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult:...