Viewing 15 posts - 2,731 through 2,745 (of 9,253 total)
rupert.hirst (11/18/2014)
Ok, I'm with you, yes I was missing the specific -d <dbname> parameter, and with this added, it looks to work.
With the -d parameter my connection is to the...
November 18, 2014 at 8:27 am
SQL Galaxy (11/18/2014)
Thank you for mention missed points(number), I have updated my documents.
No, they are still a very high level, you need to be looking a lot deeper into this....
November 18, 2014 at 6:49 am
You've missed out very important steps and all of this is required before you even get to creating and configuring a listener. This is still at a very high level,...
November 18, 2014 at 5:30 am
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...
November 18, 2014 at 5:21 am
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...
November 18, 2014 at 5:21 am
can't see the database name specified
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.
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...
November 17, 2014 at 9:26 am
you'll need to remove A from the Log shipping plan then
November 17, 2014 at 8:23 am
to use one common virtual IP, AlwaysOn group with a listener is the only option
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)
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...
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"...
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?
November 16, 2014 at 3:48 pm
Viewing 15 posts - 2,731 through 2,745 (of 9,253 total)