none
sql recovery models for sharepoint databases RRS feed

  • Question

  • Guys I would like to ask about sql server database recovery models in terms of sharepoint. By default the SharePoint Config, Content and Admin databases are set to FULL and the SSP and Search databases are set to Simple. I understand why content databases are set to full but I'm not sure why one would want to set config, admin, and ssp databases to full. Any help you guys can provide is much appreciated
    Wednesday, October 7, 2009 2:45 AM

Answers

  • Hi,

     

    Using which recover model depends on your real requirement, I think the default recovery models is based on the high availability considerations.

     

    If you configure SQL Server database mirroring, the mirroring works only with databases that use the full recovery model.

    However, the transaction log size SSP database may become very large, that should be the cause why the default setting was setting to simple.

     

    Please refer to Configure availability in a single farm by using SQL Server database mirroring (http://technet.microsoft.com/en-us/library/dd207314.aspx) for more information.

    ·         Mirroring works only with databases that use the full recovery model.

    By default, Office SharePoint Server 2007 SSP databases are configured to use the Simple recovery model. To configure database mirroring, the recovery model of the database must be set to Full. For information about how to set the recovery model for a database, see How to: View or Change the Recovery Model of a Database (SQL Server Management Studio) (http://go.microsoft.com/fwlink/?LinkId=132075&clcid=0x409).

    ·         If you plan to mirror SSP databases, consider that the transaction log size of these databases may become very large. To work around this, consider having a recovery plan that truncates transaction logs as necessary. For more information, see the following article in the Microsoft Knowledge Base: How to stop the transaction log of a SQL Server database from growing unexpectedly (http://go.microsoft.com/fwlink/?LinkId=111458&clcid=0x409).

     

     

    Hope the information can be helpful.

    -lambert


    Sincerely,
    Lambert Qin | Microsoft TechNet Managed Forum Support
    Posting is provided "AS IS" with no warranties, and confers no rights.
    • Marked as answer by Lu Zou-MSFT Friday, October 16, 2009 9:26 AM
    Thursday, October 8, 2009 2:43 AM