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 ...