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 ...
Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond 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.
