Notes and Resources from SQL User Group Session on SharePoint - Chandima.Net Blog for SharePoint solutions

Notes and Resources from SQL User Group Session on SharePoint [ Posted on: 16-May-2008 ]

First of all thanks to SQL Server User Group leaders Adrian Engelbrecht and Clive Trott for the invitation to speak and to Ron van Moorsel of Prophesy for helping with the tricky SQL questions and help with demos. Also I want to thank Todd Klindt [MVP] from Solanite consulting for allowing me to re-use his original slide content from the Seattle SharePoint Conference.

As promised here are the links and resources that I used during the presentation.

Planning and Maintenance

SharePoint Server Planning and Maintenance on TechNet

Advanced Planning Lectures and White Papers

Office SharePoint Server server farm architecture (MS Word)

Describes how to plan server farms for reliability and scalability, and how to deploy Office SharePoint Server 2007 and Windows SharePoint Services 3.0 on a server farm.

Configuring SharePoint Server Farms for Backup and Recovery (MS Word)

Backing up, restoring, high availability, and disaster recovery for Office SharePoint Server server farms. Describes how to back up and recover Office SharePoint Server server farms

Database Maintenance for SharePoint Server Farms

Guidelines for using SQL Server Maintenance Wizard (MS Word)

Maintenance Wizard Guidelines (KB Article [ KB 932744 ])

Database Mirroring White Paper for SharePoint (TechNet Article)

Setup and Maintenance via Command Line

You can also install Office SharePoint Server 2007 from the command line instead of using the wizard interface. The following technical reference topics can help you understand the options available for using Setup.exe, Psconfig.exe and the Config.xml file from the command line.

Presentation Download

Download Presentation PDF "Understanding SQL Server Database Options for SharePoint" (Zip 3.5MB)

My Previous Posts about SQL Server and SharePoint

Questions on SharePoint and SQL Server

SQL Database guide for SharePoint deployments

Does your SQL server look like this after a SharePoint install?

Technorati Tags: MOSS,WSS,SQL,SQL Server,SQL User Group,SharePoint,Maintenance,Databases,Backup,Recovery

Posted by Chandima Kulathilake | 2 Comments | Bookmark with:

Tags: Deployment, Administration, SharePoint 2007, User Group

Comments and Feedback

Friday, 16 May 2008 02:19 by Todd Klindt

My pleasure Chandima. I'm sure you did it well. tk

Friday, 16 May 2008 10:52 by Pegy

Application for change user profile site disk quota, if you have too much my site web. Because SharePoint implicitly cannot change my site quota templates for all my site web at once, you can use this applications.

Your Name: (Required)
Website URL:
Your Email: (Will not be displayed)
Feedback and Comments: (Required)
Are you a person?	Please enter the charachters in the box below.


View the privacy policy.