Archive for July 2009
Limitations in 64-Bit Windows server 2003
Posted by: Manpreet Singh on: July 21, 2009
Windows Server 2003 is considered to be one of the most scalable operating system when running on 64 bit platform. But still there are some consideration which must be consider before migrating SQL Server to 64 bit enviournment
There are some limitations of windows server 2003 which must be addressed before migrating SQL server to [...]
32 Bit SQL Server 2005 Vs. 64 Bit SQL Server 2005
Posted by: Manpreet Singh on: July 21, 2009
Today, 64-bit processors have become the standard for systems ranging from the most scalable servers to desktop PCs. The way to take full advantage of these systems is with 64-bit editions of Microsoft Windows products and Microsoft SQL server.
The 64-bit systems offer direct access to more virtual and physical memory than 32-bit systems and process [...]
Resolving SQL Server 2005 SP3 Installation Problem
Posted by: Manpreet Singh on: July 14, 2009
Have you encountered a problem due to deletion of the contents of C:\Windows\Installer folder? Several times the administrators delete the contents of this folder to make the space free without knowing the consequences. All the previous installation files get stored to this folder specifically the update\patches files which comes in to use when we upgrade the [...]
All About SQL server 2005 Clustering and Windows Clustering
Posted by: Manpreet Singh on: July 9, 2009
Basic hardware requirement
Minimum two servers with windows server 2003 datacenter, enterprise or standard edition (Two node clustering only).
Shared storage (SQN, ISCSI) etc. with Minimum 3 partitions (for Quorum (500 MB), MSDTC(2 GB) and Data files (Depends))
Minimum 2 Network card per server for public and private network with 500-millisecond or less round-trip response time
Nodes must be [...]
