Uninstall SQL Server 2008 Cluster

 

Here goes the SQL Server 2008 un-installation screenshots.

SQL Server 2008 Service Pack 2 - Installation

 

Here Let me show the step by step on SQL Server 2008 SP 2 Installation

 

Can we have SQL Server 2000 default Instance and SQL Server 2005 default Instance on the same server?

The default instance could be an installation of

SQL Server 2000,
SQL Server 2005,
SQL Server 2008, or
SQL Server 2008 R2.

Only one installation of SQL Server, regardless of version, can be the default instance at one time

SQL 2000 SP4 Installation Error sp_vupgrade_replication(1)

 

Error

• Msg 170, Level 15, State 1, Server MS, Line 1

Line 1: Incorrect syntax near '-'.

The sqlsp.log file indicates:

Process Exit Code: (0)

Error running script: sp_vupgrade_replication (1)

Action CleanUpInstall:

Installation Failed.

Resolution:
1. Check if distribution database exist though the Replication is dropped
2. If so drop the distribution database
3. To drop the distribution database by over - restoring of some user database
4. Perform the patching / SQL SP again.

SQL2000 SP4 Installation Error sp_vupgrade_replication(1)

 

SQL Server 2005 Patching fails CREATE DATABASE failed.

Error:

Error Number : 29537

Error Description : MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]CREATE DATABASE failed.
Some file names listed could not be created. Check related errors.. To continue, correct the problem, and then run SQL Server Setup again.

CAUSE:
By default the setup creates the Temp_MS_AgentSigningCertificate_database Database on specified default database location,
If the location doesn't exist, it fails to create the database and the setup fails.

RESOLUTION:
1. In SSMS, go to Server Properties > Database Settings > Database Default Locations ,check default location for Data and Log .

2. Try to access locations specified at Data and Log, Make sure files are available there.
3. If any of the files missing from above location , we hit the above error.
4. In that case, change the path to point to reall location of mdf/ldf files .
5. Setup should now succeed.

1. Reference: a recently applied update, kb955706, failed to install

SQL Server Default Collation

Technorati Tags: SQL Server Setup

 

SQL Server Default Collation

SQL Server 2005 may take up to 24 hours to install...

While performing of SQL Server 2005 installation on Windows 2003 Server in a network after waiting
for over an hour for SQL Server 2005 to install, I decided to check the knowledge base just in case.




Lucky I did...

SQL Server 2005 may take up to 24 hours to install...

http://support.microsoft.com/kb/910070/en-us