The main SQL server is on a SQL 2005 cluster. It is time for an upgrade to SQL 2008. This will be an interim measure until the hardware refresh the later half of 2012. The main aim of the process is…
SQL Database showing Suspect.
I got a call saying one of the SQL database was unable to connect. In the management studio (SQL 2008), the database is flagged as “Suspect” Microsoft suggests looking at the SQL server error log. All it says was connection…
SQL Express 2008
This is the first time I used SQL Server 2008 Express. A most interesting experience. First off there are several types, database only, management tools only, both and Advanced Services that comes with reporting services. I installed the database only…
Network Load Balancing
Microsoft Load Balancing Service. It is very similar in to Cluster Service in setup, but administration is quite different.
How wide is it?
I was tooling around Microsoft SQL server in preparation for a 64 bit migration when I came across this interesting command. xp_msver It returned the following for my Intel box. 1 ProductName NULL Microsoft SQL Server 2 ProductVersion 589824 9.00.4035.00…
Installing SQL 2005 cluster
SQL 2005 cluster installation, requires all RDP sessions to be logged out.
SQL Server migration
The databases on a sql server are located in the Data directory. This is usually located on a non system partition. So that database growth will not affect system stability. What happens you got a new spanking SAN?