
354 SOF T WARE ENGINEERING AND TESTING
Microsoft SQL Server 2000 data and transaction log files must not be placed on
compressed file systems or a remote network drive (shared network directory).
It is recommended that you specify a maximum size to which the file is permitted
to grow. This prevents the file from growing as data is added, until disk space is
exhausted. To specify a maximum size for the file, go to the Restrict filegrowth (MB)
option in the Properties dialogue box in the SQL Server Enterprise Manager.
20.5 HOW TO CREATE A DATABASE USING ENTERPRISE
MANAGER
1. Expand the Microsoft SQL Servers in the Console Root and then expand ...