View Complete Post
I downloaded some project from some site which is made in VS 2003. When I open its project file in Notepad I get following at first line Microsoft Visual Studio Solution File, Format Version 8.00. I don't have VS 2003 in my PC but I have VB 2005 and 2008 Express Edition. Now I wanted to upgrade that file but it is not doing. Can somebody help to upgrade it.
Hello All !
I have a MSCS cluster Windows 2003 Ent SP2 R2 (2 nodes en Active / Passive) and I install SQL 2005 SP3. I need to install 2 MS SQL Server instances on this cluster.
I have volumes shared disks: - Q for Quorum, M for MSDTC, L for logs, S for Datas, T for TempDB, X for Indexes
I want to put system databases on Y.
I have a doubt:
I have 2 SQL instances (ISQL1 and ISQL2), do I need a separate volume for the system DBs (master, model, msdb, tempdb) per instance?
or do I need one volume for all the system DB (Y) for the 2 instances?
Here is my current setup
2 node cluster with 5 SAN disks
I have 2 SQL Network names setup with 1 SQL instance on each
I would like to create another instance called
PRODSQL2K5\MSSQLSERVER_2 using disks M:\ and N:\
Is this possible and is there a document I can follow. I ran thru the setup, but it wants me to create a new virtual name or can I add this thru the cluster management software. The servers are running Server 2008 Enterprise and I am running
SQL 2005 Enterprise
Our production server is currently running SQL 2005 on a stand alone machine. SQL Server is installed as a default instance.
Can we upgrade to a cluster without having to change the instance name i.e currently applications connect to this server with hostname of the server i.e SERVERA, can we install a cluster such that sql server can still be called SERVERA.