![]() ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |