由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - A question about SQL 2000 server shutdown
相关主题
shutdown 200+ SQL SERVERS in 45 minutesRe: A question for SQL Server
how to register SQL Server in intranetSQL server 和SQL anywhere的区别是什么?
Any SSIS high hand here?SQL Server stupid questions
什么也不懂,要考个SQL Server 的证Question
journal for sql serverwhat is Microsoft SQL server 's version number?
请问Enterprise level experienceSQL Server 2000: When?
请教MS SQL的CHECKPOINTOne question on SQL Server
看看这database server 要升极吗how to particially delete record in sql server
相关话题的讨论汇总
话题: sql话题: server话题: shutdown话题: xp话题: ups
进入Database版参与讨论
1 (共1页)
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?

1 (共1页)
进入Database版参与讨论
相关主题
how to particially delete record in sql serverjournal for sql server
SQL Server restore(transferred from other DB) error... HELP!请问Enterprise level experience
help: SQL Server数据同步复制请教MS SQL的CHECKPOINT
[转载] SQL Server 2000看看这database server 要升极吗
shutdown 200+ SQL SERVERS in 45 minutesRe: A question for SQL Server
how to register SQL Server in intranetSQL server 和SQL anywhere的区别是什么?
Any SSIS high hand here?SQL Server stupid questions
什么也不懂,要考个SQL Server 的证Question
相关话题的讨论汇总
话题: sql话题: server话题: shutdown话题: xp话题: ups