Viewing 15 posts - 6,361 through 6,375 (of 9,241 total)
James_B (3/17/2011)
2. ensure you are logged on with local admin privileges
more importantly, the account you run the service pack under must have admin access to the sql server instance. If...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2011 at 8:59 am
Regardless, when you're adding a new node you need to attach any storage that the cluster groups rely on
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2011 at 4:45 am
Correct, attach after the OS is built and before attempting to install SQL server.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2011 at 1:56 am
ananda.murugesan (10/17/2011)
I want to perform SQL2KR2 Mirroring Configuration with witness server. for automatic failover perform.
1. Principle Server - (port 5022 opened) and installed SQL2KR2 on default instance, IP Address- 10.4.54.XXX,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2011 at 9:43 am
ALZDBA (10/17/2011)
Perry Whittle (10/11/2011)
Dev @ +91 973 913 6683 (10/11/2011)
I believe ‘;’ is an ANSI SQL statement terminator which you can use with other RDBMS as well.
Oracle uses it...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2011 at 5:52 am
ananda.murugesan (10/14/2011)
after that I have successfully installed cluster failover setup in corporate domain controller.
not sure what you mean by this, can you explain further please?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 15, 2011 at 1:00 am
You're going to need to supply more information.
Have you checked the windows event logs and the cluster.log
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 15, 2011 at 12:58 am
use a server side trace to capture workloads from key points in the business day and then feed this too DTA.
DTA only recommends and all of these should be tested...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 14, 2011 at 5:55 pm
you will need shared storage that both nodes can access
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 14, 2011 at 10:43 am
use reporting service scripter to extract all objects and then import to the new instance.
http://www.sqldbatips.com/showarticle.asp?ID=62
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 14, 2011 at 8:53 am
you can create a windows cluster with just one node, then add nodes later on. Important to fresh build server A after the migrations and introduce it into the new...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 14, 2011 at 8:34 am
Leave server A as a stand alone machine. Form a cluster on Server B and install your clustered instances. Move databases, logins, jobs, etc to the new instances and re...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 14, 2011 at 5:29 am
ananda.murugesan (10/14/2011)
after that I have successfully installed cluster failover setup in corporate domain controller.
not sure what you mean by this?
ananda.murugesan (10/14/2011)
also add second node.
so you ran sql server setup...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 14, 2011 at 5:24 am
bailifei2011 (10/14/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 14, 2011 at 2:50 am
there's probably a way through Powershell to do this but i just havent had time to explore it yet 🙂
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 14, 2011 at 2:41 am
Viewing 15 posts - 6,361 through 6,375 (of 9,241 total)