Experimenting with clustering -- sql server clustering

crbd98 NO[at]SPAM yahoo.com
10/30/2003 8:53:08 AM

Dear Friends,

This is new environment to me. Therefore, I would appreciate your
comments and suggestions.

This is the scenario. I have two SQL servers 2000 (standard edition)
connected to a shared storage. I moved all the database files to the
shared drive.

To my surprise, I noticed that I can attach those files to each
database server and perform simultaneous operations. Do I have to do
anything special to assure the consistency of operations and the
resulting data? Does SQL server takes care of acccess control,
therefore serializing conflicting accesses?

Still in a SAN environment, but a different problem: I also have a
service running in each server monitoring the "health" of each server.
In the case of failure, the service brings down the "primary" server
and elects the backup as the good server. In the case of shared files,
do I have to do anything special to switch from one server to the
other? What if I have more than 2 servers?

Thank you

Linchi Shea
10/30/2003 1:44:49 PM

If what you have described is true that both servers can
access the shared disks at the same time, your files there
will be corrupt. If it's not corrupt yet, it's just a
matter of time. You are in a very messy situation.

To get out that situation, you need to totally rebuild
your entire system and reformat your disks.

One of the primary purposes of the Microsoft Cluster
Service is to prevent the shared disks from being 'shared'
at the same time.

Linchi

[quoted text, click to view]

rboyd NO[at]SPAM onlinemicrosoft.com
10/30/2003 8:07:48 PM

If both of the servers can access both drives at the same time there is
something fundamentally wrong with the setup. A shared drive should only be
accessed from one server at a time.

Rand
This posting is provided "as is" with no warranties and confers no rights.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clustering

sql server clustering : Experimenting with clustering