Viewing 15 posts - 2,731 through 2,745 (of 9,241 total)
rupert.hirst (11/18/2014)
Hi,Yes, sorry, I didn't make that clear, the database name is in the script:
Select * from <db>.<schema>.<table>
Cheers
Roop
Ok, let me expand a little, i can't see the database name in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2014 at 5:21 am
how you getting on?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2014 at 5:18 am
can't see the database name specified
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2014 at 9:34 am
Most modern RAID10 controllers will push very good read performance purely because all the disks in the array are usually used.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2014 at 9:30 am
SQL Galaxy (11/17/2014)
Thank you Mr. Perry.Could you Pl. provide links or any document for how to configure listener in always on group?
Do you know how to deploy an AlwaysOn...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2014 at 9:26 am
you'll need to remove A from the Log shipping plan then
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2014 at 8:23 am
to use one common virtual IP, AlwaysOn group with a listener is the only option
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2014 at 5:12 am
options without shared storage are
traditional database mirroring (requires at least std edition of sql server)
AlwaysOn groups (requires at least enterprise edition of sql server)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2014 at 4:49 am
Adam Bean (11/16/2014)
it's in the AG creation script above.
mmm, nope, just been through your script and there are no readonly routing urls or secondary\primary configuration scripts. Please read my guide
Adam...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2014 at 4:04 pm
you have added a listener but I can't see the scripts to configure your readonly routing?
See my guide at this link[/url] and scroll down to the section "Configure ReadOnly Routing"...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2014 at 3:54 pm
you want B to take the primary role, is that correct?
what do you plan to do with A?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2014 at 3:48 pm
can you provide details of the scripts you used to define the read only routing configuration (obfuscate any computer names and domain, etc)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2014 at 10:32 am
adeel.imtiaz (11/15/2014)
Node 1 : windows 2008 R2 + SQL Cluster 2012Node 2 : windows 2008 R2 + SQL Cluster 2012
I highly recommend you use Windows 2012 R2...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2014 at 10:29 am
i don't think UK postcodes are an exact measurable science i could be wrong. They are assigned on a street level and one long street will usually have many postcodes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2014 at 3:43 pm
GraveD (11/14/2014)
We have 2-node SQL Server 2008 R2 Cluster. I'm going to add a new node with SQL Server 2014 and then, after some time, upgrade the cluster to SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2014 at 3:25 pm
Viewing 15 posts - 2,731 through 2,745 (of 9,241 total)