Viewing 15 posts - 7,531 through 7,545 (of 9,244 total)
Ok, as far as I remember SP3 does not have the single node install issue that affects SP2!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2010 at 1:21 am
OK, it's important to know this to keep a handle on the growth!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 4:11 pm
on the active node go into add\remove programs. Select SQL Server 2005 and click the change button. Set up will launch, select the clustered instance you wish to install the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 3:52 pm
so what produced this mammoth amount of fle growth and subsequent free space in the first place? Shrinking blindly without knowing the initial cause, it could just grow again!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 3:35 pm
vijay82 (10/16/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 3:30 pm
AWE works in conjunction with PAE which extends the bus from 32 bits to 36 bits. You need PAE support in the OS to use Address Windowing Extensions!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 3:26 pm
turfnsurf4me (10/18/2010)
MSSQLsvc/<machine name>:1433 and with the FQDN
This is incorrect, when running SQL Server under the context of a user account the SPN is bound to that user and not the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 3:14 pm
Duran
It's only SQL Server 2008 that has the shared folder location issue, which itself is fixed in a later CU. SQL Server 2008 R2 as far as I am aware...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 3:06 pm
is this a Windows 2003 or Windows 2008 cluster?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 2:34 pm
which file occupies the most space and has the most free space?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 2:32 pm
Abdul
as already stated you do not need to put the SQL server instance into single user mode to modify the file paths for model and msdb databases. Also, do not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 2:20 pm
Duran (10/18/2010)
Should I run and add node B now to make it a 2 node cluster, or should I install the other instances (Mulit-Instance) on node A first?
It doesn't...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 2:16 pm
as Brandie states you probably have the client tools install disk only. The CD format has 2 disks and the second disk has client tool install only. The DVD image...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 8:16 am
Doug
Could you confirm you see the following?
➡ splash screen appears when disk autoruns
➡ click install server components and wizard starts
➡ accept EULA and click...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 7:19 am
Jeff Moden (10/18/2010)
Not quite so with your code.
Junk the snippy little aggregate function on the rownum with gaps too 🙂
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 6:01 am
Viewing 15 posts - 7,531 through 7,545 (of 9,244 total)