Viewing 15 posts - 4,201 through 4,215 (of 9,253 total)
A well formed Windows cluster is a pre requisite for a clustered sql server instance.
First you must cluster the Windows operating system on the computer nodes. Once this is done...
April 16, 2013 at 12:18 am
In the folder
C:\Windows\System32\Drivers\etc
You'll find the HOSTS file here and also one titled SERVICES. Open the SERVICES file and it contains details of ports already assigned to services on the...
April 15, 2013 at 3:10 pm
sql-lover (4/15/2013)
April 15, 2013 at 3:03 pm
ramyours2003 (4/15/2013)
What are the pre requisites to install cluster in sql 2008
Windows 2003 or Windows 2008?
Main pre reqs are
functional...
April 15, 2013 at 5:58 am
pete_20 (4/14/2013)
We are running DBCC CHECKDB WITH ALL_ERRORMSGS.
After couple of minutes, the execution fails, sql service crashes and we get the following error:
Msg 64, Level 20, State 0, Line 0
A...
April 15, 2013 at 5:56 am
are you saying you just want to check the data is identical for each row across all columns?
April 15, 2013 at 5:41 am
You'll need to use aliases within the SQL Server configuration manager, these are detailed here.
April 15, 2013 at 5:39 am
deep_kkumar (4/12/2013)
so that one instance running on node B and node c never fails over to node A.
Simple don't install the instance to NodeA 😉
If you do install the instance...
April 12, 2013 at 11:53 am
deep_kkumar (4/12/2013)
Thanks Perry. Too many questions.
You're welcome, i don't mind, really.
deep_kkumar (4/12/2013)
April 12, 2013 at 11:11 am
deep_kkumar (4/12/2013)
Perry,Do we need to have multiple witness disks if we want to go with this type of setting?
A cluster will have only 1 witness if one is required, this...
April 12, 2013 at 10:07 am
winston Smith (4/11/2013)
Someone mentioned recently that you can set it up using a full backup,...
April 11, 2013 at 9:36 am
Roust_m (4/10/2013)
So I understand I would have to re-install the default and the named instances to make them failover
Correct, but you would have to remove the stand alone instances first...
April 11, 2013 at 12:38 am
dan-572483 (4/10/2013)
What is the purpose of additional server nodes if you're not going to extend the SQL cluster there?
The whole idea of creating a multi node cluster is to...
April 10, 2013 at 10:06 am
Please see this Microsoft link for further details
April 10, 2013 at 4:47 am
Not sure i understand exactly what you are asking but i wouldnt cluster a machine that already has stand alone instances of sql server installed.
Clusters support the same instance naming...
April 10, 2013 at 2:35 am
Viewing 15 posts - 4,201 through 4,215 (of 9,253 total)