Archive for the ‘Administration’ Category
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 [...]
Changing Collation of SQL server Database
Posted by: Manpreet Singh on: June 30, 2009
As we all know that collation is a important part of Sql server storage engine. The collation defines who data is stored in Sql Server. The physical storage of character strings in Microsoft® SQL Server™ is controlled by collations. A collation specifies the bit patterns that represent each character and the rules by which characters [...]
SQL Installation Server Setup Checklist
Posted by: Manpreet Singh on: June 26, 2009
Before Install
Create at least one new Active Directory account for SQL Server.
This is best practices, and a popular shortcut is to run all of the database servers under the same service account. I’ve run into two problems with this approach. First, I’ve had a sysadmin repeatedly fat-finger the service account password, thereby locking out [...]
System Databases in SQL server 2005
Posted by: Manpreet Singh on: May 26, 2009
Whenever we install new SQL server instance on server, it include four system databases by default named: Master, Model, Tempdb, and MSDB. It also contains a fifth, stealth database that you will never see using any of the normal SQL tools or commands. This database is referred to as the resource database, but its actual [...]
Find percentage of work completed in SQL Server 2005
Posted by: Manpreet Singh on: May 25, 2009
Yesterday, I and my friend were taking manual backup of database on development server through management studio and suddenly management studio stop responding. I knew that this is happening due to the load added by backup process. We were wondering if there is any TSQL statement through which we can find the status of task [...]
Configuring Active Directory and Domain Controller
Posted by: Manpreet Singh on: May 19, 2009
Installing Active Directory needs static IP address. This can be assign by selecting network card properties and then typing in the IP address we wish to use. The subnet mask must also be provided. Both values must be correctly chosen given the networking configuration of the network that the cluster will be a part of. [...]
