Viewing 15 posts - 6,361 through 6,375 (of 9,244 total)
ananda.murugesan (10/20/2011)
please suggestion me, What changes required in ASP web application for database connectivity? whenever modify ALTER DATABASE MyDB SET PARTNER FAILOVER.Thanks
ananda
The instance name in the connection string would obviously...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2011 at 4:06 am
This will remove the mirror session!
kapfundestanley (10/20/2011)
On the mirror
ALTER DATABASE <database name> SET PARTNER OFF
RESTORE DATABASE <database name> WITH RECOVERY
when the principal...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2011 at 3:08 am
Imaan (10/19/2011)
We have 2...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2011 at 9:55 am
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
Viewing 15 posts - 6,361 through 6,375 (of 9,244 total)