locked
resources on SQL Server maintenance on SharePoint? RRS feed

  • Question

  • I'm both a new DBA (extensive web dev and MSSQL dev experience, though).  I'm supporting a back-end for MOSS-2007 portal with extensive sites and site collections for U.S. Army (sub-contractor).

    I've read some of the whitepapers on TechNet and MSDN.  Does anyone know other good blogs, or websites for "how-to's" on best practice SQL Server maintenance plans and administration of SharePoint SQL Server databases?

    Thanks,

    Zee  (Atlanta GA)
    SQL Server DBA - MOSS 2007 environment
    General Dynamics I.T.
    • Moved by Mike Walsh FIN Monday, October 19, 2009 1:44 PM general q (From:SharePoint - Setup, Upgrade, Administration and Operation)
    • Edited by Mike Walsh FIN Monday, October 19, 2009 1:44 PM ? added
    Monday, October 19, 2009 1:38 PM

Answers

  • Have you read Bill Baer's paper on MOSS DB maintenence:

    http://go.microsoft.com/fwlink/?LinkId=111531&clcid=0x409

    If you are looking for information on how to tune and optimize for scale, then other than the obvious technet plethora, this is a very good read:
    http://www.webperformanceinc.com/library/casestudies/sharepoint/SharePointLoadTesting.pdf

    Regards

    John Timney
    • Marked as answer by Lily Wu Tuesday, October 27, 2009 12:36 AM
    Monday, October 19, 2009 3:51 PM