vurmart.blogg.se - Sql master database

Changing server or database configuration valuesĭo not create user objects in master.Creating, modifying, or dropping any database.When you work with the master database, consider the following recommendations:Īlways have a current backup of the master database available.īack up the master database as soon as possible after the following operations:

Setting the database or primary filegroup to READ_ONLY.

Renaming the database or primary filegroup.

Removing the primary filegroup, primary data file, or log file.

Dropping the guest user from the database.Creating triggers on system tables in the database.Creating a full-text catalog or full-text index.The default collation is the server collation.

Backups, only a full database backup can be performed on the master database.The following operations cannot be performed on the master database: Database optionįor a description of these database options, see ALTER DATABASE (Transact-SQL). For Azure SQL Database single databases and elastic pools, the user has no control over these database options.