Notes and Resources from SQL User Group Session on SharePoint
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.
SharePoint Server Planning and Maintenance on TechNet
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.
Setup.exe command-line reference (Office SharePoint Server)
Config.xml reference (Office SharePoint Server)
Download Presentation PDF “Understanding SQL Server Database Options for SharePoint” (Zip 3.5MB)
Questions on SharePoint and SQL Server
SQL Database guide for SharePoint deployments
Does your SQL server look like this after a SharePoint install?