为什么每次开机之后，SQL Server 2008 中的好几个数据库都显示“正在恢复“？求高手解释啊！ SQL2008中三种恢复模式的区别在哪里?
sql server 2008 \u670d\u52a1\u4e2d\u7684sql server\u670d\u52a1\u65e0\u6cd5\u542f\u52a8\u539f\u56e0\uff1asql server\u670d\u52a1\u6ca1\u6709\u8bbe\u7f6e\u542f\u52a8\u3002
1\u3001\u9996\u5148\u6253\u5f00\u7535\u8111\uff0c\u53f3\u952e\u5355\u51fb\u6211\u7684\u7535\u8111\u9009\u62e9\u6253\u5f00\u201c\u7ba1\u7406\u201d\u3002
2\u3001\u7136\u540e\u5728\u5f39\u51fa\u6765\u7684\u7a97\u53e3\u4e2d\u70b9\u51fb\u6253\u5f00\u670d\u52a1\u548c\u5e94\u7528\u7a0b\u5e8f\u4e2d\u7684\u201c\u670d\u52a1\u201d\u9009\u9879\u3002
3\u3001\u7136\u540e\u5728\u5f39\u51fa\u6765\u7684\u7a97\u53e3\u4e2d\u627e\u5230\u201cSQL SERVER(MSSQLSERVER)\u201d\u3002
4\u3001\u7136\u540e\u9f20\u6807\u53f3\u952e\u5355\u51fb\u9009\u62e9\u201c\u542f\u52a8\u201d\u5c31\u5b8c\u6210\u4e86\u3002
SQL Server\u6570\u636e\u5e93\u6709\u4e09\u79cd\u6062\u590d\u6a21\u5f0f\uff1a\u7b80\u5355\u6062\u590d\u6a21\u5f0f\u3001\u5b8c\u6574\u6062\u590d\u6a21\u5f0f\u548c\u5927\u5bb9\u91cf\u65e5\u5fd7\u6062\u590d\u6a21\u5f0f\u3002
Simple \u7b80\u5355\u6062\u590d\u6a21\u5f0f,
Simple\u6a21\u5f0f\u7684\u65e7\u79f0\u53eb\u201dCheckpoint with truncate log\u201c\uff0c\u5176\u5b9e\u8fd9\u4e2a\u540d\u5b57\u66f4\u5f62\u8c61\uff0c\u5728Simple\u6a21\u5f0f\u4e0b\uff0cSQL Server\u4f1a\u5728\u6bcf\u6b21checkpoint\u6216backup\u4e4b\u540e\u81ea\u52a8\u622a\u65adlog\uff0c\u4e5f\u5c31\u662f\u4e22\u5f03\u6240\u6709\u7684inactive log records\uff0c\u4ec5\u4fdd\u7559\u7528\u4e8e\u5b9e\u4f8b\u542f\u52a8\u65f6\u81ea\u52a8\u53d1\u751f\u7684instance recovery\u6240\u9700\u7684\u5c11\u91cflog\uff0c\u8fd9\u6837\u505a\u7684\u597d\u5904\u662flog\u6587\u4ef6\u975e\u5e38\u5c0f\uff0c\u4e0d\u9700\u8981DBA\u53bb\u7ef4\u62a4\u3001\u5907\u4efdlog\uff0c\u4f46\u574f\u5904\u4e5f\u662f\u663e\u800c\u6613\u89c1\u7684\uff0c\u5c31\u662f\u4e00\u65e6\u6570\u636e\u5e93\u51fa\u73b0\u5f02\u5e38\uff0c\u9700\u8981\u6062\u590d\u65f6\uff0c\u6700\u591a\u53ea\u80fd\u6062\u590d\u5230\u4e0a\u4e00\u6b21\u7684\u5907\u4efd\uff0c\u65e0\u6cd5\u6062\u590d\u5230\u6700\u8fd1\u53ef\u7528\u72b6\u6001\uff0c\u56e0\u4e3alog\u4e22\u5931\u4e86\u3002Simple\u6a21\u5f0f\u4e3b\u8981\u7528\u4e8e\u975ecritical\u7684\u4e1a\u52a1\uff0c\u6bd4\u5982\u5f00\u53d1\u5e93\u548c\u6d4b\u8bd5\u5e93\uff0c\u4f46\u662f\u9053\u5bcc\u8fd9\u8fb9\u7684SQL Server\uff08\u5373\u4f7f\u662f\u751f\u4ea7\u5e93\uff09\u5927\u90fd\u91c7\u7528Simple\u6a21\u5f0f\uff0c\u662f\u56e0\u4e3a\u8fd9\u8fb9\u7684SQL Server\u5927\u90fd\u7528\u4e8e\u975ecritical\u7684\u4e1a\u52a1\uff08critical\u7684\u6570\u636e\u5e93\u5927\u90fd\u91c7\u7528Oracle\u548cDB2)\uff0c\u53ef\u4ee5\u5fcd\u53d7\u5c11\u4e8e1\u5929\u7684\u6570\u636e\u4e22\u5931(\u6211\u4eec\u7684job\u6bcf\u5929\u90fd\u4f1a\u5b9a\u65f6\u5907\u4efd\u5168\u5e93\uff09\u3002
Full \u5b8c\u6574\u6062\u590d\u6a21\u5f0f,
\u548cSimple\u6a21\u5f0f\u76f8\u53cd\uff0cFull\u6a21\u5f0f\u7684\u65e7\u79f0\u53eb\u201dCheckpoint without truncate log\u201c\uff0c\u4e5f\u5c31\u662fSQL Server\u4e0d\u4e3b\u52a8\u622a\u65adlog\uff0c\u53ea\u6709\u5907\u4efdlog\u4e4b\u540e\uff0c\u624d\u53ef\u4ee5\u622a\u65adlog\uff0c\u5426\u5219log\u6587\u4ef6\u4f1a\u4e00\u76f4\u589e\u5927\uff0c\u76f4\u5230\u6491\u7206\u786c\u76d8\uff0c\u56e0\u6b64\u9700\u8981\u90e8\u7f72\u4e00\u4e2ajob\u5b9a\u65f6\u5907\u4efdlog\u3002Full\u7684\u597d\u5904\u662f\u53ef\u4ee5\u505apoint-in-time\u6062\u590d\uff0c\u6700\u5927\u9650\u5ea6\u7684\u4fdd\u8bc1\u6570\u636e\u4e0d\u4e22\u5931\uff0c\u4e00\u822c\u7528\u4e8ecritical\u7684\u4e1a\u52a1\u73af\u5883\u91cc\u3002\u7f3a\u70b9\u5c31\u662fDBA\u9700\u8981\u7ef4\u62a4log\uff0c\u589e\u52a0\u4eba\u5458\u6210\u672c\uff08\u5176\u5b9e\u4e5f\u5c31\u662f\u591a\u4e86\u5b9a\u65f6\u5907\u4efdlog\u8fd9\u9879\u5de5\u4f5c\u800c\u5df2\uff09\u3002
Bulk-logged \u5927\u5bb9\u91cf\u65e5\u5fd7\u6062\u590d
Bulk-logged\u6a21\u5f0f\u548cfull\u6a21\u5f0f\u7c7b\u4f3c\uff0c\u552f\u4e00\u7684\u4e0d\u540c\u662f\u9488\u5bf9\u4ee5\u4e0bBulk\u64cd\u4f5c\uff0c\u4f1a\u4ea7\u751f\u5c3d\u91cf\u5c11\u7684log\uff1a1) Bulk load operations (bcp and BULK INSERT).2) SELECT INTO.3) Create/drop/rebuild index\u4f17\u6240\u5468\u77e5\uff0c\u901a\u5e38bulk\u64cd\u4f5c\u4f1a\u4ea7\u751f\u5927\u91cf\u7684log\uff0c\u5bf9SQL Server\u7684\u6027\u80fd\u6709\u8f83\u5927\u5f71\u54cd\uff0cbulk-logged\u6a21\u5f0f\u7684\u4f5c\u7528\u5c31\u5728\u4e8e\u964d\u4f4e\u8fd9\u79cd\u6027\u80fd\u5f71\u54cd\uff0c\u5e76\u9632\u6b62log\u6587\u4ef6\u8fc7\u5206\u589e\u957f\uff0c\u4f46\u662f\u5b83\u7684\u95ee\u9898\u662f\u65e0\u6cd5point-in-time\u6062\u590d\u5230\u5305\u542bbulk-logged record\u7684\u8fd9\u6bb5\u65f6\u95f4\u3002Bulk-logged\u6a21\u5f0f\u7684\u6700\u4f73\u5b9e\u8df5\u65b9\u6848\u662f\u5728\u505abulk\u64cd\u4f5c\u4e4b\u524d\u5207\u6362\u5230bulk-logged\uff0c\u5728bulk\u64cd\u4f5c\u7ed3\u675f\u4e4b\u540e\u9a6c\u4e0a\u5207\u6362\u56defull\u6a21\u5f0f\u3002
是否搭建了实例故障转移？如果是就可能出现这种情况
说明有事务在回滚或者前滚。
扩展阅读：sql提示重复键值怎么处理 ... sql去重三种方法 ... sql当前时间减去某个时间 ... 电脑开机后进不了系统 ... sql和python哪个难学 ... sql被挂起的解决方法 ... sql错误怎么解决 ... 查询一段时间内的数据sql ... sql重复键怎么办 ...
