Before you rename a database , you should make sure that no one is using the database and that the database is set to single - user mode 在重命名数据库之前,应该确保没有人使用该数据库,而且该数据库设置为单用户模式。
When you start an instance of sql server in single - user mode , only a single user can connect , and the checkpoint process is not started 在单用户模式下启动sql server实例时,只能连接一个用户,并且不启动checkpoint进程。
When the 60 seconds are up , init shuts down the processes that aren t used in the single - user mode and brings the system back up in single - user only mode 到了60秒时, init会关闭单用户方式中不使用的进程,并使系统进入单用户方式。
This topic describes how to set a user - defined database to single - user mode by using object explorer in sql server management studio 本主题说明了如何使用sql server management studio中的对象资源管理器将用户定义数据库设置为单用户模式。
If you attempt to start it while the server is in single - user mode , an error will be returned and database engine tuning advisor will not start 如果试图在服务器处于单用户模式时启动该服务器,将返回错误,并且不会启动数据库引擎优化顾问。