SQL 2008 Mirroring HA option for MOS2007 Sharepoint Farm

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
goprasadAsked:
Who is Participating?
 
Jerryuk007Commented:
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
 
goprasadAuthor Commented:
Any one?
0
 
Jerryuk007Commented:
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
 
goprasadAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.