This chapter comes from our "SQL Server 2000 Database Administration" course
Visit the course home page for full details (such as the videos in the course, free videos for the course, and more)

Chapter 4: Working with SQL Server Databases: Creation, Management and Best Practices

This chapter discusses the various ways to create databases, how to manage your database files by expanding or shrinking SQL Server's database files, how filegroups work, and Best Practices for SQL Server databases

Videos in Chapter 4

1	An Overview of the Database Files - Data Files (MDF), the Transaction Log (LDF) and Additional Data Files (NDF)	Download
2	Creating Databases with the SQL Server Enterprise Manager	Download
3	Creating Our First Database - Three Techniques	Download
4	Enterprise Manager - Put Table On Filegroup	Download
5	How to Increase a Database's Size - Multiple Techniques for Increasing Data File and Transaction Log File Size	Download
6	How to Increase a Database's Size Using the SQL Server Enterprise Manager	Download
7	Setting Database Options Using the Enterprise Manager - Setting the Database State Options	Download
8	Shrinking Database Files and Removing Space from Your SQL Server Database (Using Enterprise Manager)	Download
9	Database Compatibility Levels and sp_dbcmptlevel	Download

Login

Chapter 4: Working with SQL Server Databases: Creation, Management and Best Practices

Videos in Chapter 4