9.1. Database file configuration
In previous chapters, we've seen how default SQL Server installations come with good out-of-the-box settings that lessen administration requirements, strengthen security, and maximize performance. When it comes to individual databases, there are a number of recommended configuration steps that SQL Server doesn't perform, in large part due to dependencies on disk configuration and unknown future usage of the databases.
Before covering specific file configuration recommendations, let's address some of the terms used when discussing database files:
Primary data file—The primary data file, and by default the only data file, contains system tables and information on all files within a database. By default, this file ...
Get SQL Server 2008 Administration in Action 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.
