Viewing 15 posts - 3,016 through 3,030 (of 9,253 total)
mqbk (8/28/2014)
Is there a way to be able to do this with writes? Can I have in essences 2 masters that some how reconcile with each other?
No, that is not...
August 28, 2014 at 8:52 am
Wheres the information for the second availability group?
August 27, 2014 at 12:32 pm
i see no readonly routing urls, no secondary connections allowed and no listener details in the output from the 2nd query!
August 27, 2014 at 10:13 am
Please send me the outputs of these queries
SET CONCAT_NULL_YIELDS_NULL OFF
SELECT'AlwaysOn Group ' + QUOTENAME(AG.NAME) + ' has the following members;'
FROM SYS.availability_groups AG
UNION
SELECT'Replica ''' + ar.replica_server_name + ''' identified...
August 27, 2014 at 8:29 am
enriquemallon (8/27/2014)
You get "Access is denied.". So, it seems like the service account for SQL Server doesn't have permissions on where you try to produce the backup file.
The error is...
August 27, 2014 at 8:18 am
DBANewbie (7/9/2013)
I can resolve this by dropping and recreating the mirroring session
And that's exactly what Books Online tells you to do 😉
August 27, 2014 at 8:17 am
I'm assuming this is your configuration
ServerA ...
August 27, 2014 at 7:40 am
Koen Verbeeck (8/27/2014)
but they already have the hardware...
There would still usually be a nominal cost to cover hardware, maintenance and OS licensing
August 27, 2014 at 4:00 am
there will undoubtedly be a cost which your dept may be expected to fund
August 27, 2014 at 3:20 am
rstone (8/26/2014)
August 27, 2014 at 2:12 am
Check my guide at this link[/url]. It details machines in a workgroup but is also relevant to different domains too
August 27, 2014 at 2:08 am
muthyala_51 (8/26/2014)
plan to setup AG on in both default and named instance of two nodes. Can we do it ? any suggestions ?
yes you can, each instance must be on...
August 27, 2014 at 2:04 am
The links below detail how to change the IP and network name, you will of course have to ensure the resources are offline on the old cluster first.
August 26, 2014 at 12:40 pm
its still not clear and doesn't make complete sense. you can only have 1 default instance in the cluster the rest must be named.
August 26, 2014 at 9:12 am
ramana3327 (8/26/2014)
First we have to run the upgrade adviser to know the potential issues.
Yes, this is a basic requirement, you want to know where compatibility issues will lie.
ramana3327 (8/26/2014)
August 26, 2014 at 8:28 am
Viewing 15 posts - 3,016 through 3,030 (of 9,253 total)