請教：數(shù)據(jù)庫的狀態(tài)各表示什么意思？

trytodoit

用select * from sysdatabases 看見有一列為staut,也曾看見以前文章介紹用改更此值可以解決一些問題（比如：狀態(tài)可疑），請問當(dāng)為0 ，12， -32768 等值時(shí)分別表示什么意義？

chuxu

十進(jìn)制十六進(jìn)制狀態(tài)
1 0x01 在此數(shù)據(jù)庫上啟動(dòng)了升級
2 0x02 升級已成功
4 0x04 · select into/bulkcopy· 可由用戶設(shè)置
8 0x08 · trunc log on chkpt· 可由用戶設(shè)置
16 0x10 · no chkpt on recovery· 可由用戶設(shè)置
32 0x20 用 for load 選項(xiàng)創(chuàng)建數(shù)據(jù)庫（否則在裝載數(shù)據(jù)庫時(shí)崩潰），用于指示不進(jìn)行恢復(fù)
64 0x04 為要恢復(fù)的所有數(shù)據(jù)庫啟動(dòng)恢復(fù)
256 0x100 · 可疑數(shù)據(jù)庫· 未恢復(fù)· 無法打開或使用· 只能用 dbcc dbrepair 刪除
512 0x200 · ddl in tran· 可由用戶設(shè)置
1024 0x400 · read only· 可由用戶設(shè)置
2048 0x800 · dbo use only· 可由用戶設(shè)置
4096 0x1000 · single user· 可由用戶設(shè)置
8192 0x2000 · allow nulls by default· 可由用戶設(shè)置

black_chr

好貼。收藏一下。順便再問一下，如果出現(xiàn)狀態(tài)是320的情況下，該如何處理呢？

trytodoit

謝謝版主的指點(diǎn)，那-32768  (十六進(jìn)制的8000)又代表什么意思呢？

小無賴

我遇到320的時(shí)候都是把satats設(shè)為-32768啟動(dòng)數(shù)據(jù)庫后用dump tran ... with no_log清一遍日志,然后把stats改為0重啟數(shù)據(jù)庫,重設(shè)數(shù)據(jù)庫選項(xiàng)后做個(gè)全庫的DBCC,看看有沒有表壞了.

小無賴

原帖由 trytodoit 于 2007-6-21 09:06 發(fā)表
謝謝版主的指點(diǎn)，那-32768  (十六進(jìn)制的8000)又代表什么意思呢？

-32768表示不在啟動(dòng)時(shí)恢復(fù)此數(shù)據(jù)庫.

Sybase技術(shù)專家

狀態(tài)320表示：
320= 256 + 64
256和64的解釋：
64 0x04 為要恢復(fù)的所有數(shù)據(jù)庫啟動(dòng)恢復(fù)
256 0x100 · 可疑數(shù)據(jù)庫· 未恢復(fù)· 無法打開或使用· 只能用 dbcc dbrepair 刪除

beginner-bj

Table 12-5 lists the bit representations for the status column.

Table 12-5: status control bits in the sysdatabases table Decimal
Hex
Status

4
0x04
select into/bulkcopy

Can be set by user


8
0x08
trunc log on chkpt

Can be set by user


16
0x10
no chkpt on recovery

Can be set by user


32
0x20
Database created with for load option, or crashed while loading database, instructs recovery not to proceed

256
0x100
Database suspect

Not recovered

Cannot be opened or used

Can be dropped only with dbcc dbrepair


512
0x200
ddl in tran

Can be set by user


1024
0x400
read only

Can be set by user


2048
0x800
dbo use only

Can be set by user


4096
0x1000
single user

Can be set by user


8192
0x2000
allow nulls by default

Can be set by user



Table 12-6 lists the bit representations for the status2 column.

Table 12-6: status2 control bits in the sysdatabases table Decimal
Hex
Status

1
0x0001
abort tran on log full; can be set by user

2
0x0002
no free space acctg; can be set by user

4
0x0004
auto identity; can be set by user

8
0x0008
identity in nonunique index; can be set by user

16
0x0010
Database is offline

32
0x0020
Database is offline until recovery completes

64
0x0040
Internal use – Database is being recovered

128
0x0080
Database has suspect pages

256†
0x0100
Table structure written to disk

512
0x0200
Database is in the process of being upgraded

1024
0x0400
Database brought online for standby access

-32768
0xFFFF8000
Database has some portion of the log which is not on a log-only device

Linuxcn.com

收場了