Solved

SBS 2011 SQL 2k8R2 and SQL 2k8R2 failover

Posted on 2014-02-10
4
322 Views
Last Modified: 2014-03-04
We have SBS 2011 standard sp2 and we have configured AD, SQL 2008 R2 and file server in SBS 2011.

We need to add a new domain with windows server 2012 which will act as primary.

Further more we need to configure SQL failover as below

SBS: 2011 standard with SQL 2008 Express  and
Windows server 2012 with SQL 2008 R2.


and  file server failover as belwo
SBS: 2011 File server and
Windows server 2012 with file server role


kindly suggest......
0
Comment
Question by:rigelnet
4 Comments
 
LVL 37

Expert Comment

by:bbao
ID: 39849711
I don't think two SQL servers in different AD domains can be failed over with each other.

See below the excerpted description from MSDN.

"Windows Server 2008 R2 requires that all the cluster servers must be in the same Active Directory domain. Therefore, SQL Server multi-subnet failover cluster requires that all the cluster nodes be in the same Active Directory domain even if they are in different subnets."

FYI - Before Installing Failover Clustering

http://msdn.microsoft.com/en-us/library/ms189910.aspx
0
 
LVL 35

Expert Comment

by:Cris Hanna
ID: 39849875
not sure what you mean by failing over. If you mean having another server to handle logons, have a duplicate copy of all data files if SBS fails, it's possible BUT all servers MUST be in the same domain. SBS will not do trusts to another domain
0
 
LVL 74

Accepted Solution

by:
Jeffrey Kane - TechSoEasy earned 500 total points
ID: 39853380
We need to add a new domain with windows server 2012 which will act as primary.

No can do.  Your SBS MUST be the holder of all FSMO roles in your domain.

Rather than stating... "we need", "we need" and describing what you think the solutions should be it would be MUCH better if you described your current environment and expressed your concerns about it.

For instance, WHY do you think you need a fileserver failover?  There are plenty of ways to provide data redundancy and availability without the complexity of having to manage a replica file server. (Since you have SBS, I'm assuming that you don't have hundreds of users -- how many users DO you have?)

Just enabling Volume Shadow Copy will automatically create up to 30 "Previous Versions" of all files in network shared folders which satisfies most anyone's need for redundancy.  

As for SQL failover?  Again, what is the application you are using and does it even support database replication?

Jeff
0
 

Author Closing Comment

by:rigelnet
ID: 39902877
Thank you Jeff,

I got your point. I will keep sbs2012 with all five fsmo role  and will add 2012 server a backup.

For file server we will configure volume shadow copy.

We have around 35 users and we will install a new SQL server.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
non-domain members are not prompted for credentials 18 37
HP Storage Array 2700 Not Happy 4 31
TSQL - How to declare table name 26 29
convert null in sql server 12 31
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this Micro Tutorial viewers will learn how to restore single file or folder from Bare Metal backup image of their system. Tutorial shows how to restore files and folders from system backup. Often it is not needed to restore entire system when onl…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question