Chapter II.2. Care and Feeding of Your Database

When it comes to creating and maintaining databases, with SQL Server very little is set in stone. That is, you nearly always have a second chance to make things right, which gives you the flexibility you need to make changes. In fact, sometimes you might even need to go as far as deleting a database.

No matter what brought you to this chapter, you'll soon see how easy it is to make modifications, whether trivial or significant, to your databases. To start, you get the story on renaming a database. Next up is changing database configuration parameters to tweak your data storage engine's behavior. Finally, you walk through the exact steps necessary to delete a database.

Get Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies® 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.