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

Features

More Premium Content Accessible For Free

  • Technology advances, trends prompt ECM systems maturation
    nip_tuck_ECM.png
    E-Handbook

    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
    Information_Governance_in_Action-Success_Factors_and_Best_Practices.PNG
    E-Handbook

    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
    RethinkingWCM_final.PNG
    E-Handbook

    There's much more to managing the customer experience than simply optimizing Web content management to make things more interactive. Effective ...