Viewing 15 posts - 5,206 through 5,220 (of 9,244 total)
robert.baird 2778 (8/10/2012)
Could I in fact change the Network name of the cluster? Not the nodes, just the network name (resource).Dan
network name for the windows cluster or the clustered sql...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 10, 2012 at 9:08 am
robert.baird 2778 (8/10/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 10, 2012 at 9:06 am
muthyala_51 (7/27/2012)
i want to create a new distribution database and make the present publisher use this new distribution database.
This is bugging me :ermm:
but why do you want the present publisher...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 10, 2012 at 8:43 am
no worries. You're bang on the money about the cure\fix, I hope the OP realises what a mammoth task they have if they want to change the dist database.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 10, 2012 at 8:40 am
you only need 1 quorum disk resource, period. There are other quorum models available and depending on the number of nodes and geographical location, you could probably do away with...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 10, 2012 at 8:32 am
MysteryJimbo (8/10/2012)
A distributor can only have a single distribution database. You cannot select it as part of a publisher set up.
This is incorrect.
A distributor may have multiple distribution...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 10, 2012 at 8:28 am
matt.gyton (8/10/2012)
1. Can I specify the same network name for the second instance during setup? So the instances would be as follows...cluster1\inst1, cluster1\inst2.
No, networknames, like computernames, must be unique...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 10, 2012 at 7:19 am
tilew-948340 (8/9/2012)
The database works fine (except that users makes errors...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 10, 2012 at 7:12 am
santosh.balaraj (8/9/2012)
This operation is not supported on the primary replica of the availability group.
Failover the group before attempting to join or remove the database
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 9, 2012 at 11:33 am
alanspeckman (8/9/2012)
Browser service needed:
1. If connecting using only the instance name with a non-standard port
2. If connecting to an instance that uses dynamic ports, such as a named instance because...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 9, 2012 at 11:28 am
granny (8/9/2012)
Thanks for the information Perry!That's what I needed to know.
You're welcome.
granny (8/9/2012)
I was a little confused because of the setup differences between server 2003 & 2008
Whilst they...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 9, 2012 at 10:03 am
In that case a third node is possible
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 9, 2012 at 12:04 am
No, check with your admin, you likely have a dedicated firewall device securing the LAN from the DMZ
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 8, 2012 at 4:06 pm
sqlfriends (8/8/2012)
I don't see anything done from SQL server end.
you won't
sqlfriends (8/8/2012)
I wonder if it is a good approach, as I don't know about windows firewall.
nothing to do with...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 8, 2012 at 3:28 pm
the script would do it if it was integrated properly with the T-SQL commands to modify the file locations and offline\online the database. It just requires a little development and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 8, 2012 at 10:29 am
Viewing 15 posts - 5,206 through 5,220 (of 9,244 total)