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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.