<div>
Yes, you can set-up DB Mirroring of SharePoint Databases.<br />
But there are a few considerations if it's to be used as a Failover system...<br />
<br />
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 &quot;re-point&quot; the database to the proper server name.<br />
<br />
Hope this helps<br />
<br />
Jerry
</div>


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

<div>
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
</div>


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

<div>
<div class="content wysiwyg-content">
Hello there,<br />
<br />
We are planning to implement SQL 2008 DB mirroring as HA solution to MOS2007 SP farm. But MOS2007 is not DB Mirror aware.<br />
Is this going to be an issue? <br />
<br />
Please advise.<br />
<br />
Thanks and Regards
</div>
</div>


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

SQL 2008 Mirroring HA option for MOS2007 Sharepoint Farm

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.