Ok, as far as I remember SP3 does not have the single node install issue that affects SP2!

OK, it's important to know this to keep a handle on the growth!

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...

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!!

vijay82 (10/16/2010)

---

I am using SP3 for one applications,SP3 is already installed, in UAT, SP3 is not supporting for that application then client says that please use sp2, then how will...

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!

This is incorrect, when running SQL Server under the context of a user account the SPN is bound to that user and not the...

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...

is this a Windows 2003 or Windows 2008 cluster?

which file occupies the most space and has the most free space?

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...

It doesn't...

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...

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...

Junk the snippy little aggregate function on the rownum with gaps too 🙂