Buenas tareas

MOSS 2007 and SQL 2008

A must!

Ing. Eduardo Castro, PhD
ecastro@mswindowscr.org Comunidad Windows

Agenda
MOSS Database Review New SQL 2008 Features Relevant to MOSS
Database BackupCompression
(up to 89% less disk space)

Backup Compression with HA/DR
(restore times up to 50% less with up to 89% less network usage)

Database Mirroring Enhancements
(increase availability whilereducing network usage by up to 73%)

Failover Clustering
(much easier to install and manage with increased reliability)

Transparent Data Encryption and Backup Encryption
(encrypt all dataseamlessly)

Performance Studio, Central Management, and Policy-Based Management
(reduce DBA workload)

Additional Resources
ecastro@mswindowscr.org

Step by Step Guidehttp://andreasglaser.net/post/2008/08/14/In stalling-MOSS-2007-on-Windows-Server2008-and-SQL-Server-2008-Part-1Overview.aspx

ecastro@mswindowscr.org

SharePoint and SQL Server 2008
Any flavor of SharePoint will benefitOffice SharePoint Server 2007 (Standard or Enterprise) Windows SharePoint Services 3.0

You need SP1 to make it work!
Existing install: Upgrade to SP1 Clean install: Download SharePoint w/SP1slipstream

ecastro@mswindowscr.org

SharePoint Databases
Configuration – One per farm, stores information about the farm topology and settings Content – Stores all content; it is usual to haveseveral content databases WSS Search – Property store for WSS search SSP Search – Displayable document properties/metadata for MOSS Search Single Sign-On – SSO credential mappings SSP – Other SharedServices such as user profiles, audiences, etc.
ecastro@mswindowscr.org

Site Collections and Content Databases
Site Site Collection Content DB Site Web Application Content DB Farm Site CollectionSite Collection Site Collection Top Level Site Site Top Level Site Top Level Site Site Top Level Site Site

Web Application

Content DB Site Collection Site Collection Top Level Site Top Level...