SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Summary

In this chapter, you learned about the system and user databases that exist in a SQL Server system. You learned about files and filegroups and how they can be used to enhance the performance of SQL Server 2008 databases. You also learned about the system databases and how they should be stored and backed up periodically. Next, you explored the many configuration options available for databases through the use of properties and some of the more important ones you should be aware of.

After exploring the fundamental concepts of database creation in SQL Server, you then created databases using the GUI, T-SQL, and the Windows PowerShell command prompt. You next learned to detach and attach databases. Finally, you learned about database snapshots ...