f*****e
发帖数: 5177 | 1 I have a SQL 2000 server running on Windows XP. The machine has a UPS
attached.
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? | w*******e
发帖数: 1622 | 2 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.
【在 f*****e 的大作中提到】
: I have a SQL 2000 server running on Windows XP. The machine has a UPS
: attached.
: 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?
| a*******t
发帖数: 891 | 3 I _think_ if there is a transaction in process and the SQL server was forced
shut down, then it'll try to roll back next time you start the server
【在 f*****e 的大作中提到】
: I have a SQL 2000 server running on Windows XP. The machine has a UPS
: attached.
: 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?
| f*****e
发帖数: 5177 | 4 I read that SQL server has automatic check points. If the server was shut
down, in worst case, I lost all the data after the latest check points. Am I
right?
Is there a command to manually insert a check point?
【在 w*******e 的大作中提到】
: 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.
| w*******e
发帖数: 1622 | 5 yes, u r right.
command is "checkpoint".
I
【在 f*****e 的大作中提到】
: I read that SQL server has automatic check points. If the server was shut
: down, in worst case, I lost all the data after the latest check points. Am I
: right?
: Is there a command to manually insert a check point?
|
|
