Subscribe

SMSQL for SQL 2005 and SQL 2008

[ Edited ]

I have a customer that is looking to impliment SQL Server 2005 and SQL Server 2008 in the same cluster.  Is this a supported configuration for SnapManager for SQL?  I can check for support for one or the other, but haven't seen both on the same cluster.

Thanks,

John

Re: SMSQL for SQL 2005 and SQL 2008

Hi,

I presume that by 'cluster' you are not talking about a SQL-cluster, but a FAS-cluster.

Then, as far as I know, this is fully supported. Actually, I don't see why not. :-)

Re: SMSQL for SQL 2005 and SQL 2008

I am talking about a SQL Cluster that is running both flavors of SQL.  I haven't seen it in the wild yet, but they assure me that it is supported.

Thanks,

John

Re: SMSQL for SQL 2005 and SQL 2008

SMSQL even supports SQL Server 2000, 2005 and 2008 instances running on a single standalone server. For clustered instances, you will connect to those instances individually, so they will not interfere with each other.

Thanks,

-Qing

Re: SMSQL for SQL 2005 and SQL 2008

OK, they finally have the cluster up and running.  When the cluster was built, they created LUNs from the NetApp Cluster and used them for the database since they needed a shared resource for the cluster.  We then installed SMSQL, but now we are getting this error.  It makes sense to me that the SQL server root is on the NetApp lun because it has to be a a shared resource.  How can I correct the situation so we can "migrate" the database and get this running?  I quote migrate because it is already on NetApp LUNs...

Thanks,

John