Administering SharePoint's SQL Databases

One of the most complex aspects of a SharePoint implementation is the SQL Server 2000 database. In addition to regular administrative tasks within SharePoint and the operating system itself, SQL requires its own specific administration.

Administering SQL Server Data Files and File Groups

SQL Server databases consist of both data and log files. Each SQL Server database must have at least one database file. The first database file is referred to as the primary data file and is acknowledged as the starting point of a SQL Server database. It points to the other files or file groups in the database and is known by its .mdf file extension. SQL Server can also have additional secondary files, which would consist ...

Get Microsoft® SharePoint™ 2003 Unleashed, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.