Twitter
Google
RSSWhen should I backup the sql server master database?
One or more following operations occur , Please backup the master database.
- Creating or deleting a user database.
- If a user database grows automatically, by virtue of the autogrow feature, to accommodate new data, this does not affect master. Adding and deleting files and filegroups does not affect master.
- Adding logins or other login security-related operations.
- Database security operations, such as adding a user to a database, do not affect master.
- Changing any server-wide or database configuration options.
- Creating or removing backup devices.
- Using SQL Server Enterprise Manager to perform any of these operations.
- Configuring the server for distributed queries and remote procedure calls, such as adding linked servers, or remote logins.
