1 out of 1 rated this helpful - Rate this topic

Modifying a Database

SQL Server 2008 R2

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

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions