Access your Pro+ Content below.
How much SharePoint data can you risk losing?
This article is part of the September 2009 issue of SharePoint Insider
Microsoft Office SharePoint Server(MOSS) 2007 and SQL Server are intricately connected with SQL Server as the back-end data repository for MOSS 2007.SharePoint administrators sometimes have difficulty understanding this relationship, which can prevent them from having a full appreciation for it. One of the main challenges faced by SharePoint administrators when managing a SharePoint infrastructure is figuring out how the SQL Server recovery models affect their ability tocut data loss during database recovery operations. Each recovery model handles recovery a little differently. Specifically, the models differ in how they manage logging, which governs whether or not a SharePoint database can be recovered to the point of failure. Options for SQL server recovery models The three recovery models associated with a SharePoint database in SQL Server are: Full Simple Bulk-logged Full recovery model This approach captures and logs every database transaction, which makes it possible for administrators to restore a SharePoint database to ...
Features in this issue
Put a plan of best practices in place to get the most out of this powerful SharePoint tool.
SharePoint administrators can minimize data loss by selecting the appropriate SQL Server recovery model.
What if no one is taking your SharePoint governance policies seriously? Use these techniques to regain control.