Viewing 15 posts - 871 through 885 (of 9,253 total)
What is the best approach to refresh UAT table from Production. Tables have foreign...
March 14, 2017 at 11:09 am
sgt500 - Wednesday, March 8, 2017 7:57 AMMOVE ....
.... (18K+)
Just so i know i'm not misreading, could you please clarify what is...
March 14, 2017 at 10:36 am
the schema option column is a bitmap and defines what is replicated
March 14, 2017 at 9:35 am
query dbo.sysarticles on the published database ad the schema option column has a bitmap of what is replicated for each object
March 14, 2017 at 9:02 am
if the cluster is not designed correctly and worst case scenario.
Llets say you had 1 primary node in main site and 2 dr nodes in dr site and...
March 14, 2017 at 9:01 am
March 14, 2017 at 7:53 am
March 14, 2017 at 4:27 am
ensure you have enabled reomote procedure calls on the linked server itself
March 13, 2017 at 8:03 am
sgt500 - Wednesday, March 8, 2017 7:57 AMMAXTRANSFERSIZE=2097152,
BUFFERCOUNT=1100,
Remove the above and just go with the default transfersize and buffercount
March 13, 2017 at 6:17 am
We need to replicate 3 DBs like this, using sql transactional replication 2.way:
Server=2 (active); Database=DBco...
March 13, 2017 at 5:16 am
alex.sqldba - Monday, March 13, 2017 1:53 AMCheers Perry. That makes life easier 🙂
Note also the fileshare witness should be a separate...
March 13, 2017 at 5:10 am
Raghavender - Friday, March 10, 2017 8:12 AMHi All,Can we setup AlwaysOn feature on a cluster which don't have quorum drive configured.
You...
March 10, 2017 at 9:42 am
I have 2 nodes running AlwaysOn availability groups. When node 1 is primary and I...
March 10, 2017 at 9:23 am
Viewing 15 posts - 871 through 885 (of 9,253 total)