Modifying a Database

Creating and Maintaining Databases

Creating and Maintaining Databases

Modifying a Database

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

  • Expanding the data or transaction log space allocated to the database.

  • Shrinking the data and transaction log space allocated to the database.

  • Adding or removing data and transaction log files.

  • Creating filegroups.

  • Changing the default filegroup.

  • Change the configuration settings for the database.

  • Placing databases offline.

  • Attaching new and detaching unused databases.

  • Changing the name of the database.

  • Changing the owner of the database.

Before changes are made to the database, it is sometimes necessary to take the database out of normal operating mode. In those situations, determine the appropriate method for terminating transactions.