sql server cluster

Tags:
SQL Server
hello sir, I am working in a software firm as a DBA from last 6 months.Till now i a have done some simple tasks like migating database ,creating table, writing SP's etc. Now i have alloted a tough job to configure sql server cluster.About that i dont know anything. these are my requirements : we are having 2 servers.we need to install sql server on both system with the same name and with the same databse structure. one is having records of upto 2005 year and other with 2005 above records.through the application we have to switch on to different database.Is it possible. Kindly show me the right way. name: swapnil udasi Email: swapnil_19@sify.com
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

First off, are you attempting load balancing between the two servers or a failover cluster?

Either way, all records will be contained in a single instance with 1 or 2 servers processing data.

You can PM me if you like.

Kevin

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Bwartman
    To set up a SQL Server Cluster you'll need to review and understand the following article: http://msdn2.microsoft.com/en-us/library/ms179530.aspx If these are 2 standalone servers you'll have to purchase/acquire SAN storage to host the Quorum and SQL databases. This will get you started; good luck!
    0 pointsBadges:
    report
  • ScottGolightly
    It sounds like what you want is two different servers rather than a server cluster. From your request it seems you want a server that hosts "historical" data before 2005 and another server that hosts "current" data. In that case you can set up 2 different servers with different names and have the client configured with 2 different connection strings. The client would then determine which of the two servers to connect to in order to retrieve the information that it needs. In this case you do not need a SQL server cluster. If you need to move the data from the "current" server to the "historical" server then you can set up SQL replication or DTS/SSIS to move the data.
    0 pointsBadges:
    report
  • DaveInAZ
    I agree with Scott. Your description of the desired functionality does not indicate any need for a cluster. I'd suggest you get whoever gave you this assignment to restate to goals, so you don't waste time doing something totally unneccessary.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: