Viewing 15 posts - 5,206 through 5,220 (of 9,241 total)
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
I'm assuming this is a new share you have created for the backups is it?
\\IPaddress\share
The backup will run under the sql server agent, is this service using a pass through...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 8, 2012 at 6:19 am
didi77 (8/7/2012)
Why did it lost the sequence when I made a manualy backup log?
Because the log backup went to a location outside of the log shipping backup folder??
Can you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 8, 2012 at 3:39 am
Firstly, are these questions related to firewall configuration for a SQL server instance?
alanspeckman (8/7/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 8, 2012 at 12:17 am
Viewing 15 posts - 5,206 through 5,220 (of 9,241 total)