原来MSSQL也有shutdown的状态
SQL Express by default has 'AUTO_CLOSE' database option set to true. This means when your database has no users connected, the database status will show 'Shutdown Normal'. When a user connects to the database, it is started up and status is changed to 'Normal'. To leave the database on and available all the time, set the 'AUTO_CLOSE' option to FALSE. It can be done by running this script against each user database upon creation or after the fact: Code Block ALTER DATABASE
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8337095/viewspace-1034721/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- Exclusive access could not be obtained because the database is in use
- select the lock block in MSSQL
- startup and shutdown RAC
- housekeep arch logs (tested on AIX)
- ora-00119, ora-00131
- crsctl start crs for RAC on PRD
- wmi provider error 0x800742a2 :: MSSQL instance can not start
- [转载牛人教程和自己的实验结果] 7.手工备份恢复--复制数据库(练习9)
- ORA-12560
- Stop runnung job
