Viewing 15 posts - 1,786 through 1,800 (of 9,244 total)
simeharr (8/26/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2015 at 2:17 am
rocky123 (8/24/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2015 at 6:21 am
how much lag can be tolerated on the reporting copy?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2015 at 2:20 pm
did your LS setup specify a monitor server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2015 at 2:11 pm
what's driving the AO setup, something else or the reporting replica requirement?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2015 at 2:09 pm
JoshDBGuy (8/18/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2015 at 2:07 pm
Viewing 15 posts - 1,786 through 1,800 (of 9,244 total)