Access "How much SharePoint data can you risk losing?"
This article is part of the September 2009 issue of Creating an InfoPath development strategy
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 an arbitrary point in time. ... Access >>>
Premium Content for Free.
Developing an InfoPath development strategy
by Paul Galvin, Contributor
Put a plan of best practices in place to get the most out of this powerful SharePoint tool.
Suppressing a SharePoint rebellion
by Brien Posey
What if no one is taking your SharePoint governance policies seriously? Use these techniques to regain control.
- Developing an InfoPath development strategy by Paul Galvin, Contributor
How much SharePoint data can you risk losing?
by Ross Mistry and Shirmattie Seenarine
SharePoint administrators can minimize data loss by selecting the appropriate SQL Server recovery model.
- How much SharePoint data can you risk losing? by Ross Mistry and Shirmattie Seenarine
More Premium Content Accessible For Free
Information governance in action: Success factors and best practices
Many organizations struggle to establish information governance policies in the face of cultural challenges, immature processes and tepid executive ...
Rethinking WCM to engage and retain customers
There's much more to managing the customer experience than simply optimizing Web content management to make things more interactive. Effective ...
WCM playbook: Becoming a Web content management pro
Choosing systems and software that facilitate Web content management is more important than ever. This handbook offers tips for selecting WCM ...