Viewing 15 posts - 6,781 through 6,795 (of 9,244 total)
Erik Hansson (8/23/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 3:28 am
roughly how many rows do you delete, update, insert?
If you dont absolutely need to clear the whole table then dont use the truncate, the truncate will be fast but the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 3:23 am
Loner (8/22/2011)
If I use data mirroring, would it be better?
no, you cannot update the mirror unless you failover to it, but then its no longer a warm standby!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2011 at 2:04 pm
Ronnie Jones (8/22/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2011 at 2:02 pm
Dj463 (8/22/2011)
I mean if standalone instance name is SQL123 and IP 10.1.2.12, Then can i install a clustered instance on the same...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2011 at 1:56 pm
Dj463 (8/22/2011)
is there any way to keep the instance name same as the previous standalone instance?
if the stand alone server and the new cluster are in different domains then yes!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2011 at 9:08 am
GilaMonster (8/22/2011)
that is part of the buffer pool and is constrained by max memory.
is that correct? Although part of the same overall memory pool that is constrained by the max...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2011 at 9:05 am
do you have any Windows server level backup jobs running at all (BackupExec, etc)?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2011 at 8:25 am
Install the SSRS components on the remote server, if you want to store the SSRS databases on the cluster then select the clustered instance during the SSRS reporting configuration.
If...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2011 at 8:19 am
Colleen M. Morrow (8/1/2011)
Any problems overwriting clustered system databases with non-clustered master?
never tried it but cant see why it wouldnt work. Most of the cluster info is held in the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2011 at 4:03 am
Loner (8/20/2011)
I need to create a warm standby.
Do the standby databases need to be readable or are they purely standby? What are you trying to achieve here, DR or a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2011 at 5:09 pm
Perry Whittle (8/16/2011)
Also check the new...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2011 at 10:07 am
morrisos (8/17/2011)
What is best procedure to apply sp1 to a 2-node active\passive cluster? I already applied on active node. Do I failover...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 18, 2011 at 2:49 am
Jeff Moden (8/17/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 18, 2011 at 2:21 am
awu (8/17/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 18, 2011 at 1:14 am
Viewing 15 posts - 6,781 through 6,795 (of 9,244 total)