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 >>>
Access TechTarget
Premium Content for Free.
What's Inside
Features
-
-
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 M. Posey, Contributor
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
Creating an ECM strategy: Tips and advice
E-Handbook
Enterprise content management (ECM) systems can help organizations keep better track of documents, emails and other important unstructured ...
Developing a SharePoint collaboration strategy that gets results
E-Handbook
Consult this white paper to determine whether it's time to upgrade to a newer version of SharePoint now that SharePoint 2013 is available. Creating ...
Enterprise social: Building the business case and getting started
E-Handbook
While many organizations are realizing the benefits of enterprise social media and the tools that make it possible, it’s important to understand the ...