Viewing 15 posts - 4,201 through 4,215 (of 9,241 total)
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
It will be unaffected providing the log doesn't then run out of space afterwards.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2013 at 8:18 am
i use a combination of the date last updated and the amount of data modified
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2013 at 7:26 am
you will never be able to remove the primary data and log files they must always remain.
To remove an unwanted log file use DBCC LOGINFO against the database in question...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2013 at 7:18 am
Viewing 15 posts - 4,201 through 4,215 (of 9,241 total)