Summary
In this chapter, you’ve learned about the structure of a SQL Server 2005 system and user database including database files, filegroups, various configuration options, and methods for creating, altering, viewing, and deleting databases. You’ve also learned about the new database snapshot feature including its working, common uses, limitations, and the methods used to create, view, and delete them.
Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.
