Viewing 15 posts - 4,201 through 4,215 (of 9,244 total)
are you saying you just want to check the data is identical for each row across all columns?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2013 at 5:41 am
You'll need to use aliases within the SQL Server configuration manager, these are detailed here.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2013 at 10:06 am
Please see this Microsoft link for further details
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2013 at 2:35 am
Russell101 (4/8/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2013 at 2:33 am
iamsam.sandeep (4/9/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2013 at 2:29 am
is this a workgroup or a domain?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2013 at 2:27 am
There needs to be a trust relationship between the domains otherwise just use SQL Server authentication
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2013 at 2:17 am
dan-572483 (4/9/2013)
By delete the file do you mean something likeALTER DATABASE <dbname> REMOVE FILE <logical file name> ?
Yes, that's how you remove a file in a sql server database.
dan-572483...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2013 at 10:20 am
Viewing 15 posts - 4,201 through 4,215 (of 9,244 total)