Modifying a Database

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



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.

Community Additions