.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Best Practice ? MSSQL 2008 - cluster or virtualization or both ?

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server


I like to implement a MSSQL 2008 environment to provide database services for a Sharepoint Environment. DB must not be single point of failure.. so.. I need to act, but which direction ?

  • 2 node Windows 2008 cluster with MSSQL 2008 clustered  (physical)
  • VMWare virtualization ESXi (using snapshots, etc)
  •       1 MSSQL 2008 server storing all data in NetApp
  •       2-node MSSQL 2008 cluster storing all data in NetApp

What do you think ?


View Complete Post

More Related Resource Links

Full text search missing from one instance on one node of 3 node MSSQL 2008 cluster


Hello to all, 

I just started at a new client and on becoming familiar with the environment, I noticed that one of our instances on one node is missing the full text search option. The instance is not active on this node but I fear that if we ever need to failover it wont work.

The full text option is installed on the active node instance and the other passive node.

How do I add the full text search option to the instance on the node thats missing it ?

thank you.


SQLServer 2008 Tools and SQL 2005 Cluster

I recently built a SQL Server 2005 cluster on the o/s Windows Server 2008 R2.  I have been attempting to connect to the cluster from my Windows 7 dekstop with my SQL Server 2008 Tool set.  I have been unable to attach to this cluster since its creation. The firewall is temp off, remote connections in the surface area configuration is set to pipes and tcp/ip and the Browser surface is up and running. I ran Wireshark against the cluster and I could see that there was UDP conversations for ms-sql-m (SQL Port) but that was as far as it would get.  I am using a named instance so not using 1433, but I do see the cluster offering up high RPC ports but the client never responds after the initial UDP response. When I noticed that there was a two way conversation taking place, I went to a seperate machine and fired up SQL Server 2005 Tools and I was easily able to attach to the cluster.  So my question is - Are there any known incompatibilities between SQL Server 2005 cluster services and SQL Server 2008 Tool set?  I can use my 2008 tools to attach to a non-clustered SQL Server 2005 w/o issue.   Error when attempting to connect: A network-related or instance-specific error occured while establishing a connection to sql server.  The server was not found or was not accessible.  Verify that the instance name is correct and the SQL Server is con

MSSQL 2008 R2: Change Server Collation Steps, with user DBs already of desired collation

On the default instance of SQL Server 2008 R2, I want to change the server collation from the usual US default SQL_Latin1_General_CP1_CI_AS to an application vendor's required collation, Latin1_General_BIN.  I understand that changing the server collation is essentially the same as changing the collation of databases master and model -- is that a fair statement? But my main question is, since there are user databases on the server that I would like to preserve, can I not simply detatch the user DBs prior to performing the server collation change, and then reattach?  The database collation of the user databases is already set to Latin1_General_BIN.  This article, Setting and Changing the Server Collation, at http://msdn.microsoft.com/en-us/library/ms179254.aspx says that to preserve the user databases, I should script all DB objects out, and bulk-copy all data out, because the DBs will have to be recreated and repopulated.  Can someone explain why I ought not simply detach and reattach the user DBs, given that they are already of the desired collation (i.e., the same collation that I will be changing the server collation to)? Your help much appreciated. -Tom

Windows 2008 R2/SQL 2008 SP1 CU5 active/active cluster keeps failing

I have set up many of the same clusters in the last few months, but this cluster specifically has been having lots of problems lately.  OS: Windows Server 2008 R2 latest patches SQL: SQL Server 2008 SP1 CU5 (version: 10.0.2746) Disks: VMAX SAN In the very beginning when I set up the cluster, the cluster validation kept failing when I tried to add a node.  Turned out that we had to unjoin the servers from the domain and rejoin.  Right after that the cluster validation succeeded, the second node joined the cluster, and quorum was changed to "Node and Disk Majority".  SQL was installed and set up as active/active (one sql instance on each node).  No issues then until SQL server was actually in use.  Symptoms: SQL server has heavy ETL processing plus being a subscriber of a sql replication.  The following errors first started on 4/24 when I set up sql replication (these servers are replication subscribers): EventID: 1127, Source: FailoverCluster, Task Category: Network Manager Cluster network interface 'man1fscl01a - Hartbeat to man1fscl91b' for cluster node 'man1fscl01a' on network 'ClusterHeartBeat' failed. Run the Validate a Configuration wizard to check your network configuration. If the condition persists, check for hardware or software errors related to the network adapter. Also check for failures in any other network comp

SQL 2008 Restore on a 2008 R2 Cluster

I've built a 2008 R2 Cluster running sql 2008 as a clustered application.  We do full backups with arcserve.  I'm trying to come up with a process to get the cluster back online for disaster recovery.  I can get the Windows cluster back online but when it comes to sql I get stuck.  Would I basically get the cluster back online than use the command - setup /action=rebuilddatabase /instancename=MSSQLServer /sqlsysadminaccounts=domain\username?  Than start the database in single user mode, install the arcserve sql agent and restore all the db's? When I try this I get the error element does not exist error.  Right, now I'm starting from scratch to see if I get the same result.  I just want to make sure I'm on the right track and not spinning my wheels trying something that won't work in a clustered application.   Thanks,   Matt

SQL Server 2008 R2 installation on a server which is in cluster

Hello, I want to install SQL Server 2008 R2 on a machine which is in a cluster. Is there any issue in doing this? Regards

SQL Server 2008 Agent Fails to start in a Win 2008 Cluster

When I try to bring SQLAGENT Online, I get the following errors: EventID:53 [sqagtres] StartResourceService: Failed to start SQLSERVERAGENT service.  CurrentState: 1 [sqagtres] OnlineThread: ResUtilsStartResourceService failed (status 435) [sqagtres] OnlineThread: Error 435 bringing resource online.   I just did a fresh SQL Cluster install as well.  When I installed the cluster, the service account was good to go.  I cant figure out what is going on.  SQL Server Engine starts fine.  Any ideas?

Extended stored procs on 64 bit MSSQL 2008

We need to develop some extended stored procedures for 64-bit SQL Server 2008. We have written the DLL in Visual C++ but when we try to register it with the database, we see the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not load the DLL c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\xp_test.dll, or one of the DLLs it references. Reason: 193(failed to retrieve text for this error. Reason: 15105).(42000,17750) Procedure(xp_test) Can anyone please tell me if you have come across such an issue and how it was successfully resolved? 

SQL 2008 64 Bit 2 node cluster

I wanted to get some feedback on how much memory and CPUs I needed for each node in a 2 Node Cluster. The operating System will be Windows 2008 R2 64 bit Enterprise and the SQL version will be SQL 2008 R2 64 Bit. It will have a total of 8 instances of SQL Server. 2 of those instances will be SQL Server Reporting Services ( 1 SQL Native and the other SharePoint enabled). This cluster will have both nodes in a virtual enviroment. Any feedback would be greatly appreciated.

named instance sql server 2008 install on cluster

I have a production two-node cluster with sql server 2008 sp1 cu7 running over windows server 2008 sp2. If I were to install a new named instance on this live environment, would it impair the default sql server instance functionality? I'm not referring to processor/io while the install is in progress. My question specifically is would the install process by its nature bring down the default instance. I'm pretty sure it won't, but don't see any documentation that would confirm this. thanks.

Best practice for user defined error messages in SQL Server 2005/2008 --Need help

My requirement is to setup a standard practice for our team in handling DB erros and also  user defined messages. We are handling exceptions using Raiseerror method with in Try and Catch blocks.  For user defined message, we are using Sp_addmessage to add our application specific error/warning messages with error codess>80000.  Ex: 80001 | Company name already exists. please check. Here is the sample code ********************************************************************* CREATE PROCEDURE [dbo].[usp_CompanyProfile_insert]  -- Add the parameters for the stored procedure here  (@company_name VARCHAR(50),  @company_code VARCHAR(3),  @user_id INT  ) AS BEGIN  -- SET NOCOUNT ON added to prevent extra result sets from  -- interfering with SELECT statements.  SET NOCOUNT ON;  BEGIN TRY -- Begin Try Block      -- Validate company name   IF EXISTS (SELECT company_id FROM companyprofile WHERE company_name = @company_name)    RAISERROR(90021, 16, 1)      INSERT INTO companyprofile (company_name,       company_code,       createdby)   VALUES(@company_name,     @company_code,     @user_id)    END TRY  -- End Try Block &


Platform:   2 servers (clustered) with windows server 2008 x64 r2 (enterprise) Application: sql2008 x64 enterprise with SP1 (slip streamed) Problem: sql2008 new cluster install fails using the COMMAND LINE with a CONFIGURATIONFILE.INI The install starts but stops with the log file in the setup bootstrap folder  => (Detail_ComponentUpdate.txt) below. Bottom lines indicate a REBOOT is required; did a reboot on both nodes and still have the same problem. Used the following command line to launch sql2008 setup: Setup.exe /Q /SQLSVCPASSWORD="**********" /AGTSVCPASSWORD="**********" /ASSVCPASSWORD="**********" /ISSVCPASSWORD="**********" /RSSVCPASSWORD="**********" /ConfigurationFile=ConfigurationFile.ini Anyone has any success installing sql2008 using command line and command file? thanks john ------------------------------- tail end of the Detail_ComponentUpdate.txt file ----------------------------------------------- 2010-09-01 15:59:44 Slp: ------------------------------------------------------------ 2010-09-01 15:59:44 Slp: C:\SQL2008 Enterprise with SP1\x64\FixSqlRegistryKey_x64.exe exit code: 0 2010-09-01 15:59:44 Slp: Launching external tool: C:\SQL2008 Enterprise with SP1\x64\FixSqlRegistryKey_x86.exe 2010-09-01 15:59:44 Slp: ------------------------------------------------------------ 2010-09-01 15:59

VS 2010 MSSql 2008, ASP.net and Win 7

What is all the confusion about this combination of software?  Thsi appears to be the latest versions and one would think that it would also be the most up to date versions to use with the latest OS.  But I cannot find out where to learn how to use the tools because there does not appear to be any lessons oor tutorials free or paid that provide the latest releases of these tools.  I cannot get a demonstration of installation or a how to use that matches what I have on my system.  This just does not make any sense for this to be this obtuse.  I started out trying to learn ASP.NET and I have found myself in a quaqmire of installation issues operation issues,  warinings etc and yet no definitive tool for learining how to use the latest versions.  Can some one tell me where to go I do not mind paying for a tutorial or course that will get me aquainted with the technology.  AS it is I become more confused at each corner.  I can see  why many people just go with PHP and MYSQL with WAMP SERVER or XAMP.  This is border line ridiculous is this the future of this " powerful technology"?Hoping for the best, MIKE E

Easy install package vs MsSQL server 2008

Is there anything i wont be able to do if i use SQL Server Express Database from the downlod install package offered on asp.net? Ive used MSSQL server 2008 and 2005, but to be honest i think it might be overkill cause im not very familiar with those applications. I just need the database for creating websites. Will i be able to remote connect to my webbhotel host and remotely modify the database on the remote server?Now i have a mess, i have installed both MsSQL 2005 and 2008 and im not even sure wich database is created with what. I would love to just have one simple setup, but im not sure if i can manage to migrate the databases to the new computer with this easy install package.The easy install package contains: ASP.NET and ASP.NET MVC Visual Studio 2010 Express Development Tool SQL Server Express DatabaseThanks for your time!

SSRS 2008 on cluster suggested/supported?

Hello all, I am a windows admin with intermediate knowledge of SQL Server and its components like SSRS. Anyway, I built a production SQL2008 cluster successfully. The head developer also wanted to install SSRS2008 on one of the nodes along with a custom .NET framework application. Needless to say I did get SSRS2008 installed on the active node, but starting having problems with the cluster services and other strange happenings. So I removed SSRS2008 from the node and created a VM, installed SSRS2008 ENT(gonna have to uninstall/reinstall Standard) on that and created the databases via the config wizard and this vm is also running the custom .NET framework application. All of the DBAs agreed that this should have not been installed on the cluster. Now I have to justify why I did this...... 1. For a Production cluster environment isn't is suggested to have ssrs installed on a separate server with it's database housed on the cluster? ( I was told this was an "old school" way of thinking by the developer). 2. Is having SSRS installed on one node of the cluster supported by Microsoft?  In my humble opinion, a database cluster is meant for housing databases only for high availability and nothing else should be present on these two nodes.  Is there any documentation for SSRS that suggests the seperate server deployment rather than including t

Upgrade SQL Server 2000 to SQL Server 2008 in Cluster--Recomendations

Hi all I have   6 cluster environments and 10 standalone servers and mix  of  32 bit  64 bit. As I know In place Upgrade not possible SQL2k 32 bit to SQL2008 64 bit. What I want to know is……… 1. If I purchase SQL Server 2008 Ent edition that will have both 64 bit and 32 bit edition or I have purchase separately ? 2. How to do side by side upgrade in Cluster environment I mean I can’t ask my company to provide other cluster to do side by side upgrade. If I do installation in same cluster machines, I can’t provide same Instance name for SQL Server 2008 Instance.hance it is very difficulty for application connectivity Please some body provides me best approach to drive in Upgrade from SQL2k to SQL2008. Thanks in Advance      SNIVAS

SQL server 2008 failover cluster install

Hello all, Looking for the definitive answer with supporting documentation (link). Does a SQL server 2008 cluster have to be installed as or run as a domain service account or can local accounts be used?  I looked for a document that stated yes or no and could not find one. If anyone can provide info it would be much appreciated. Have all ready looked at these 2 links of interest. http://msdn.microsoft.com/en-us/library/ms143504.aspx#Service_SID http://technet.microsoft.com/en-us/library/cc731002(WS.10).aspx Thanks in advance,  
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend