Viewing 15 posts - 1,786 through 1,800 (of 9,253 total)
simeharr (8/27/2015)
Thank you for your thorough reply.
You're welcome
simeharr (8/27/2015)
Synchronous operation is maintained in the following manner:
1. On receiving a transaction from a client, the...
August 27, 2015 at 2:37 pm
simeharr (8/26/2015)
August 27, 2015 at 2:17 am
rocky123 (8/24/2015)
August 27, 2015 at 1:54 am
vsamantha35 (8/25/2015)
Need a query help.
I am running SQL 2014 2-node AlwaysON Availability groups, Enterprise Edition in our environment
and 5 databases are part of AG.
Question is, sometimes AG is getting...
August 27, 2015 at 1:51 am
can you be a little more specific?
it seems that log shipping may be better suited if you can tolerate some lag, easier to setup and maintain
August 21, 2015 at 9:18 am
SSRS is not cluster aware, you can use network load balancing however.
If installing a standalone component such as SSRS into a WSFC with clustered instances of SQL Server, then you...
August 20, 2015 at 6:29 am
there are many articles available, too many to link. A simple google search will provide you a list
August 20, 2015 at 6:22 am
i1888 (8/20/2015)
there are both primary replicas on both node A and B, so it is balanced...
Yes, but they'll be members of different AlwaysOn groups. Keep your AG backups segregated from...
August 20, 2015 at 6:21 am
how much lag can be tolerated on the reporting copy?
August 20, 2015 at 6:14 am
if every page in the source database is modified then the sparse files can be as large as the database files so you'll need to plan for the potential space...
August 20, 2015 at 6:11 am
krypto69 (8/18/2015)
I am trying to create a job that runs against my High Availability listener server.
It is a fairly simple SQL statement in the job - execute tsql.
When I...
August 19, 2015 at 2:32 pm
tempdb is probably the easiest, simply note the folder path to the database.
Shut down the instance and blow away the volume, recreate it as required.
Set your folder paths up and...
August 19, 2015 at 2:20 pm
did your LS setup specify a monitor server?
August 19, 2015 at 2:14 pm
if you put a dedicated dtc into the resource group for the instance it will serve you dont usually need to create the mapping, having said that it cant hurt
August 19, 2015 at 2:11 pm
what's driving the AO setup, something else or the reporting replica requirement?
August 19, 2015 at 2:09 pm
Viewing 15 posts - 1,786 through 1,800 (of 9,253 total)