Viewing 15 posts - 7,411 through 7,425 (of 9,244 total)
Launch the sql server 2008 installer on node b and select add node to a sql server failover cluster.
Step through the wizard and when prompted select the default instance...
November 13, 2010 at 4:28 am
hydbadrose (11/12/2010)
but this is sql 2008 servers. will you follow the same method or through the installer?
So why have you posted in the SQL Server 2005 forum then???
No, the install...
November 12, 2010 at 4:55 pm
To add node b to the default clustered instance go into add\remove programs on the active node and under the currently installed programs click the SQL Server 2005 entry and...
November 12, 2010 at 1:20 pm
you have to launch the installer on the passive node and select the option "add node to a SQL Server failover cluster".
November 12, 2010 at 11:53 am
BL Hayes (11/11/2010)
These were recommended to improve the performance of the SQL server.
by who?
I would recommend you change this
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003,
Standard" /noexecute=optout /fastdetect /execute /nopae /3GB /Userva=2650
To this
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows...
November 11, 2010 at 11:57 am
Dave D. (11/11/2010)
the idea that every node has it's own resource database doesn't sound logical to me.
It's to allow the removal of updates and service packs.
November 11, 2010 at 6:58 am
when you install SQL Server 2005 it creates a series of groups on the windows server, these groups are provisioned into the SQL Server instance. Add your windows account to...
November 9, 2010 at 5:18 pm
BL Hayes (11/9/2010)
[operating systems]multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Standard" /noexecute=optout /fastdetect /execute /nopae /3GB /Userva=2650
The boot.ini setting did not apply on reboot. The boot is wrong........?
:crazy:
Why have you added these options?
/execute /nopae...
November 9, 2010 at 4:30 pm
This is nothing to do with AD. Check your DNS server and more specifically, your reverse lookup zone for that subnet, it'll probably be in there!!
November 5, 2010 at 8:15 am
Hi
sorry, my bad. I had posted the same link twice but have corrected that now. Right click the link and download the file before trying to open!!
November 5, 2010 at 8:11 am
K. Brian Kelley (11/4/2010)
Yeah, but it's only a couple of extra clicks and if I was an attacker, I would use what you just said to do exactly that. 🙂
Sorry,...
November 4, 2010 at 6:42 pm
That would be something wouldn't it.
SQL Server is managed in the same way you would manage a normal instance of SQL Server, what changes is the complexity of the...
November 4, 2010 at 6:08 pm
Chris Kitchen (11/4/2010)
Active/Active/Active/Passive configuration.
This is a misconception, a cluster is either Active\Active or Active\Passive!
Chris Kitchen (11/4/2010)
1.
Can...
November 4, 2010 at 5:44 pm
K. Brian Kelley (11/4/2010)
November 4, 2010 at 4:51 am
Have you tried a recompile of the procedure on the server where it takes time to execute, could be a bad cached plan.
November 3, 2010 at 1:26 pm
Viewing 15 posts - 7,411 through 7,425 (of 9,244 total)