Viewing 15 posts - 6,361 through 6,375 (of 9,253 total)
itsamarnath (10/21/2011)
Perry Whittle (10/21/2011)
itsamarnath (10/21/2011)
We have 2 instances running Inst1 and Inst2 on these nodes..Both...
October 21, 2011 at 3:43 am
DMarvez (10/19/2011)
I've read the post on the BuiltIn\Administrator account but can't...
October 21, 2011 at 3:40 am
be aware that preferred owner is set at the group level, possible owner is set at each resource level
October 21, 2011 at 3:32 am
itsamarnath (10/21/2011)
We have 2 instances running Inst1 and Inst2 on these nodes..Both are SQL Server...
October 21, 2011 at 3:29 am
high availability is the only mode that can use FailOverPartner as the other modes are manually failed over, with the witness it's automatic and so requires the connection string option...
October 20, 2011 at 4:21 am
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...
October 20, 2011 at 4:09 am
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...
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...
October 20, 2011 at 3:08 am
Imaan (10/19/2011)
We have 2...
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...
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
October 18, 2011 at 4:45 am
Correct, attach after the OS is built and before attempting to install SQL server.
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,...
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...
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?
October 15, 2011 at 1:00 am
Viewing 15 posts - 6,361 through 6,375 (of 9,253 total)