المدونة التالية
كافة المدونات

Moving MOM database ot different SQL server

يناير 19th, 2007 كتبها mahmoud magdy نشر في , Cluster, MOM 2005, 

3 تعليق »
, 

Post moved to:

http://busbar.blogspot.com/2008/03/moving-mom-database-ot-different-sql.html


Building active/active SQL cluster- Part2

يناير 7th, 2007 كتبها mahmoud magdy نشر في , Cluster, 

4 تعليق »
, 

In this session we will continue illustrating how to build an active/active SQL cluster, we built the cluster in the last session, we will install the SQL cluster in this session.

i prefer that you copy the installation source files to the local harddisk, i have experienced some faulty CD and hardware in my work, and it it will cause a lot of time to fix the corrupted installation specially in cluster environment.

so let us begin:

before you start in the SQL cluster installation you have to create a named instance pipe on each node for each named instance you will install, this is a very important  step or the installation will fail.

To create a named pipe fpr the installation follow steps in the following KB:

http://support.microsoft.com/kb/815431

Install SQL in ACTIVW/ACTIVE cluster environment:

- from the SQL installation source double click on setup.exe.

 

- In the Welcome creen, click on SQL server 2000 components

 

- In the install component screen, click on Install database server.

 

- In the welcome screen, click next.

 

- In the licensing screen, enter the administrator name and organization name,Click Next.

 

in the installation option, enter the first virtual server name "DBVS1".

in the fail over clustering page, enter an IP that will be associated with the failover cluster,Click Next.

 

in the cluster disk selection, seelct a

المزيد


Building Active/Active SQL cluster-part1

يناير 6th, 2007 كتبها mahmoud magdy نشر في , Cluster, 

10 تعليق »
, 

I have searched the internet for a detailed guide on how to implement SQL active/active cluster, I have implemented it couple of time before but It was so strange not finding a detailed and clear guide, most of the current articled that speaks about the subject either talking about windows 2000 clustring, or talking from a general prospective. So If you are looking for a detailed guide this one for you.

I will not talk about how to Virtualize the environment or configuring SAN/NAS there is a lot of documentation that talks about the process for VMWARE and Microsoft virtual server 2005. I will assume that you have configured every thing.
The storage is configured so that one partition for database file for instance1 and one partion for logs, the same applies for instance 2.
I will start from the building the cluster. Some of you will notice that I have removed the  domain name, this is because I used a customer real domain while capturing the screen shots, so I have removed the domain name but all you have to do is to put your domain name.
Let us start
open node 1 and open the cluster administrator and choose to create a new cluster
 

 

in the cluster name specify the cluster name "in my case otdb", click next

 

 

in the computer name select ht

المزيد