Altering Databases

When your database or transaction log grows to fill all the space allocated with create database, you can use alter database to add storage.

You can add space for database objects or the transaction log, or both. You can also use alter database to prepare to load a database from backup.

Permission for alter database defaults to the database owner, and is automatically transferred with database ownership. . alter database permission cannot be changed with grant or revoke.

Note: alter database for proxy update drops all proxy tables in the proxy database.
Related tasks
Changing Database Ownership