BOL中的建议相当含糊:
Back up master as often as necessary to protect the data sufficiently
for your business needs. We recommend a regular backup schedule,which
you can supplement with an additional backup after a substantial
update.
如果你冒险further,你会发现这些细节:
The types of operations that cause master to be updated,and that
require a backup to take place,include the following:@H_404_16@Creating or deleting a user database. @H_404_16@If a user database grows automatically to accommodate new data,
master is not affected. @H_404_16@Adding or removing files and filegroups. @H_404_16@Adding logins or other operations that are related to login
security. @H_404_16@Database security operations,such as adding a user to a database,
do not affect master. @H_404_16@Changing server-wide or database configuration options. @H_404_16@Creating or removing logical backup devices. @H_404_16@Configuring the server for distributed queries and remote procedure
calls (RPCs),such as adding linked servers or remote logins.
因此,如果我们所有的登录都是通过Windows组添加的,并且我们不对数据库进行任何其他更改,这是否意味着对主服务器的一次性备份就足够了?
如果不是,master数据库的标准备份间隔是多少?