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.