Modifying a Database

After a database is created, changes can be made to its original definition.

In This Section

Topic Description

Expanding a Database

Describes how to increase the size of a database.

Shrinking a Database

Describes how to reduce a database

Adding and Deleting Data and Transaction Log Files

Describes how to add and delete data and log files.

Setting Database Options

Describes how to set database options.

Detaching and Attaching Databases

Describes how to detach and attach databases.

Moving Database Files

Describes how to move data and log files and also Full-text catalogs.

Renaming a Database

Describes how to rename a database.

Changing the Database Owner

Describes how to change the owner of a database.

See Also


Creating a Database (Database Engine)
Viewing Database Metadata
Deleting a Database

Other Resources

Implementing Databases

Help and Information

Getting SQL Server 2005 Assistance