Premium Content

Access "How much SharePoint data can you risk losing?"

Ross Mistry and Shirmattie Seenarine Published: 28 Nov 2012

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

What's Inside


More Premium Content Accessible For Free

  • Data analytics might be the cure for enterprise content clutter

    The flow of data traveling into the enterprise today is largely unstructured, leaving companies with a vast amount of information to manage, archive ...

  • Technology advances, trends prompt ECM systems maturation

    Technology trends like mobile devices, cloud computing and remote workforces have brought new demands to the arena of enterprise content management. ...

  • 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 ...