发信人: wildhorse (黑马 -- 我是珠丝), 信区: Database
标 题: Re: A question about SQL 2000 server shutdown
发信站: BBS 未名空间站 (Wed Aug 1 12:31:13 2007), 转信
1. OS will shutdown all the apps.
2. depends on your recovery strategy.
If you did not have log backup, then, you lost every thing.
If you have log backup, you may save some.
【 在 flyfire (flyfire) 的大作中提到: 】
: I have a SQL 2000 server running on Windows XP. The machine has a UPS
: During power outrage, the UPS kicks in and runs for several minutes. Then
: the XP goes to shutdown process. My question is, how does the SQL server
: handles the shutdown request from hosting OS? If there is a transaction in
: process, what will happen?
※ 来源:·BBS 未名空间站 海外: mitbbs.com 中国: mitbbs.cn·[FROM: 207.67.]