?
Solved

SQL 2008 Mirroring HA option for MOS2007 Sharepoint Farm

Posted on 2011-10-19
4
Medium Priority
?
294 Views
Last Modified: 2012-08-13
Hello there,

We are planning to implement SQL 2008 DB mirroring as HA solution to MOS2007 SP farm. But MOS2007 is not DB Mirror aware.
Is this going to be an issue?

Please advise.

Thanks and Regards
0
Comment
Question by:goprasad
  • 2
  • 2
4 Comments
 

Author Comment

by:goprasad
ID: 36997165
Any one?
0
 
LVL 6

Expert Comment

by:Jerryuk007
ID: 36998593
Yes, you can set-up DB Mirroring of SharePoint Databases.
But there are a few considerations if it's to be used as a Failover system...

The main one being that the mirror database is likely to reside on another SharePoint Server (different name). Therefore, you will need to use the stsadm command to "re-point" the database to the proper server name.

Hope this helps

Jerry
0
 

Author Comment

by:goprasad
ID: 36998921
Can you please explain what happens when failover occurs? Whats steps do we need to undertake to redirect traffic from front-end servers to Mirror server
0
 
LVL 6

Accepted Solution

by:
Jerryuk007 earned 2000 total points
ID: 36999641
When failover occur (assuming you are not using a Witness in your mirroring for auto failover), you need to set the failover database to "normal mode" so you can actually select it.

You then use the stsadm command on the Web Front-End Server(s) to re-map SharePoint to the proper database server.
The first database you need to worry about is of course the Config Database.

Have a look at http://technet.microsoft.com/en-us/library/cc261956%28office.12%29.aspx

Also another method can be found at:
http://blogs.msdn.com/b/ronalg/archive/2007/09/20/change-the-sql-server-in-a-moss-2007-wss-3-0-farm.aspx

One solution might be to:
- create a brand new farm on the new server
- mirror the Content DB from production to the failover system (not the config database!)
- When failing over, enable the mirrored Database.
- Using stsadm on the WFE Servers, re-attach the mirrored content database to the new (failover) environment.
- Re-create the search database.

I haven't try that solution yet but it might work without creating too much overhead...

Jerry
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Loops Section Overview

809 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