sql server cluster
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
Software/Hardware used:
Software/Hardware used:
ASKED:
March 10, 2006 6:51 AM
UPDATED:
March 17, 2006 10:21 AM
Answer Wiki:
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
To see all answers submitted to the Answer Wiki: View Answer History.
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!
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.
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.