dbname(suspect)//置疑USE master GO sp_configure 'allow updates', 1 GO RECONFIGURE WITH OVERRIDE GOupdate sysdatabase set status=0 where name='your db name' gosp_configure 'allow updates', 0 GO RECONFIGURE WITH OVERRIDE GO执行完,重启服务器,看看你的数据库怎么样
多谢Haiwer兄 我这就去试一下, 又要坐车还要坐船,哎! 解决了的话就另外开贴给分
bzszp 兄从Oracle转向MS SQL Server了嘛。呵呵。新增数据库并新增设备后先停掉服务,然后将数据文件和日志文件覆盖。 (如以前数据和日志都用一个设备则该次也用一个设备,并保证数据和日志分配的空间比例和前次相同,如以前各用一个设备则现在也新增两设备,总之是和前次保持一致)接着开启服务,由于SQL Server检测到不匹配信息,则必定会给数据库打上质疑标志! 因此使用海兄的方法更改质疑标志,或者使用如下的方法更改: USE master GO sp_configure 'allow updates', 1 GO RECONFIGURE WITH OVERRIDE GO 使系统表可写 然后执行: sp_resetstatus 你的数据库名 最后执行: sp_configure 'allow updates', 0 GO RECONFIGURE GO经过如上的操作后,如果你每一部操作的信息都保证和前次一致而且你的运气好的话,那么就有可能成功,数据库能够正常运作。 只要有不同之处,则会失败!
错误提示的信息: Error 605:[SQL Server] Attempt to fetch logical page 256248 in database 'hmdatabase' belongs to object '0', not to object 'syslogs'.dbcc checkdb:Checking master Checking 1 The total number of data pages in this table is 23. Table has 354 data rows. Checking 2 The total number of data pages in this table is 6. Table has 64 data rows. Checking 3 The total number of data pages in this table is 39. The number of rows in Sysindexes for this table was 1125. It has been corrected to 1124. Table has 1124 data rows. Checking 4 The total number of data pages in this table is 1. Table has 26 data rows. Checking 5 The total number of data pages in this table is 5739. Table has 26282 data rows. Checking 6 The total number of data pages in this table is 822. Table has 4426 data rows. Checking 7 The total number of data pages in this table is 1. Table has 3 data rows. Checking 8 The total number of data pages in this table is 1. The number of data pages in Sysindexes for this table was 78. It has been corrected to 1. The number of rows in Sysindexes for this table was 2646. It has been corrected to 26. *** NOTICE: Notification of log space used/free cannot be reported because the log segment is not on its own device. Table has 26 data rows. Checking 9 The total number of data pages in this table is 4. Table has 247 data rows. Checking 10 The total number of data pages in this table is 1. Table has 6 data rows. Checking 11 The total number of data pages in this table is 1. Checking 12 The total number of data pages in this table is 16. Table has 744 data rows. Checking 13 The total number of data pages in this table is 1. Checking 14 The total number of data pages in this table is 1. Checking 15 The total number of data pages in this table is 1. Table has 1 data rows. Checking 16 The total number of data pages in this table is 1. Checking 17 The total number of data pages in this table is 1. Checking 18 The total number of data pages in this table is 1. Checking 30 The total number of data pages in this table is 1. Table has 7 data rows. Checking 31 The total number of data pages in this table is 1. The number of rows in Sysindexes for this table was 14. It has been corrected to 13. Table has 13 data rows. Checking 33 The total number of data pages in this table is 1. Table has 6 data rows. Checking 35 The total number of data pages in this table is 1. Table has 13 data rows. Checking 36 The total number of data pages in this table is 101. Table has 2191 data rows. Checking 37 The total number of data pages in this table is 2. Table has 53 data rows. Checking 40 The total number of data pages in this table is 1. Table has 1 data rows. Checking 41 The total number of data pages in this table is 1. Checking 44 The total number of data pages in this table is 1. Checking 45 The total number of data pages in this table is 1. The total number of TEXT/IMAGE pages in this table is 16. Table has 16 data rows. Checking 766625774 The total number of data pages in this table is 68. Table has 2264 data rows. Checking 1378103950 The total number of data pages in this table is 1. Table has 8 data rows. Checking 1410104064 The total number of data pages in this table is 2. Table has 45 data rows. Checking 1442104178 The total number of data pages in this table is 1. Table has 29 data rows. Checking 1913057851 The total number of data pages in this table is 1. Checking 1945057965 The total number of data pages in this table is 1. Table has 1 data rows. Checking 1977058079 The total number of data pages in this table is 12. Table has 486 data rows. Checking 2025058250 The total number of data pages in this table is 1. Checking 2057058364 The total number of data pages in this table is 1. Checking 2089058478 The total number of data pages in this table is 1. DBCC execution completed. If DBCC printed error messages, see your System Administrator.
难搞了,除非物理修补(需要专门手段) 把TEMPDB压缩看看
那一个ACCESS数据库里面放一张表 导入SQLSERVER时用你的数据库命名 第二步还原数据库
可以看出,好多系统表的链接都不对了,看看 dbcc checktable('syslogs') 的结果。select * from sysobjects where id in (3,31) 的结果。
dbcc checktable('syslogs') 的结果: Checking syslogs The total number of data pages in this table is 1. *** NOTICE: Notification of log space used/free cannot be reported because the log segment is not on its own device. Table has 14 data rows. DBCC execution completed. If DBCC printed error messages, see your System Administrator.select * from sysobjects where id in (3,31) 的结果: name id uid type userstat sysstat indexdel schema_ver refdate crdate version deltrig instrig updtrig seltrig category cache ------------------------------ ----------- ------ ---- -------- ------- -------- ---------- --------------------------- --------------------------- ----------- ----------- ----------- ----------- ----------- ----------- ------ syscolumns 3 1 S 0 81 0 1 1900 一月 1 12:00AM 1996 四月 3 3:38AM 0 0 0 0 0 0 0 sysusages 31 1 S 0 113 0 0 1900 一月 1 12:00AM 1996 四月 3 3:38AM 0 0 0 0 0 0 0 (2 row(s) affected)
dbname(suspect)//什么意思?可疑的,
我在自己机器上试验,创建两个设备,创建一个数据库(使用这两个设备)
对数据库进行一些操作,关闭数据库
拷贝两个文件
启动服务
删除原先数据库、以及两个设备
重新创建两个相同的设备,相同名称的数据库(使用这两个设备)
关闭服务
用原来的文件覆盖新的设备文件
启动服务
发现可以,没什么问题,里面的数据也没有丢失
单实际操作就有问题,显示 dbname(suspect),是不是还要等一会儿啊
能不能帮忙制顶一下,很急啊
多谢了
GO
sp_configure 'allow updates', 1
GO
RECONFIGURE WITH OVERRIDE
GOupdate sysdatabase
set status=0
where name='your db name'
gosp_configure 'allow updates', 0
GO
RECONFIGURE WITH OVERRIDE
GO执行完,重启服务器,看看你的数据库怎么样
我这就去试一下,
又要坐车还要坐船,哎!
解决了的话就另外开贴给分
(如以前数据和日志都用一个设备则该次也用一个设备,并保证数据和日志分配的空间比例和前次相同,如以前各用一个设备则现在也新增两设备,总之是和前次保持一致)接着开启服务,由于SQL Server检测到不匹配信息,则必定会给数据库打上质疑标志!
因此使用海兄的方法更改质疑标志,或者使用如下的方法更改:
USE master
GO
sp_configure 'allow updates', 1
GO
RECONFIGURE WITH OVERRIDE
GO
使系统表可写
然后执行:
sp_resetstatus 你的数据库名
最后执行:
sp_configure 'allow updates', 0
GO
RECONFIGURE
GO经过如上的操作后,如果你每一部操作的信息都保证和前次一致而且你的运气好的话,那么就有可能成功,数据库能够正常运作。
只要有不同之处,则会失败!
sp_resetstatus 数据库名
不能执行、6。5没有这个存储过程
我用海兄的方法试了
修改了以后不是“质疑的”,但不能查看里面的东西
报error 605错误
查了一下文档,好像说是日志id有对应不起来
数据库数据文件的大小显示为数据文件+日志文件之和,
是不是syslogs系统表还要与sysdatabases里的logptr对应起来
现在已经搞的头都大了
问题总归会解决的
好好过情人节
元旦过后
或许问题有进展~~~
GOOK LUCK~
605错误:
正文:
Attempt to fetch logical page %ld in database '%.*s' belongs to object '%.*s', not to object '%.*s'.
说明:
在正文not to object '%.*s'中规定的第二个对象很可能有错误,这个错误可能是由于页链混乱,......
纠正措施:
在正文not to object '%.*s'中规定的第二个对象上运行dbcc checktable语句,或者运行dbcc checkdb和dbcc checkalloc这样:
1、贴出你说的错误原文
2、dbcc checkdb试试
2种:数据库管理器中有添加外部数据库功能,现把备份的文件COPY到相应的目录下,再在数据库管理器中添加外部文件数据库即可。
错误提示的信息:
Error 605:[SQL Server] Attempt to fetch logical page
256248 in database 'hmdatabase' belongs to object '0',
not to object 'syslogs'.dbcc checkdb:Checking master
Checking 1
The total number of data pages in this table is 23.
Table has 354 data rows.
Checking 2
The total number of data pages in this table is 6.
Table has 64 data rows.
Checking 3
The total number of data pages in this table is 39.
The number of rows in Sysindexes for this table was 1125. It has been corrected to 1124.
Table has 1124 data rows.
Checking 4
The total number of data pages in this table is 1.
Table has 26 data rows.
Checking 5
The total number of data pages in this table is 5739.
Table has 26282 data rows.
Checking 6
The total number of data pages in this table is 822.
Table has 4426 data rows.
Checking 7
The total number of data pages in this table is 1.
Table has 3 data rows.
Checking 8
The total number of data pages in this table is 1.
The number of data pages in Sysindexes for this table was 78. It has been corrected to 1.
The number of rows in Sysindexes for this table was 2646. It has been corrected to 26.
*** NOTICE: Notification of log space used/free cannot be reported because the log segment is not on its own device.
Table has 26 data rows.
Checking 9
The total number of data pages in this table is 4.
Table has 247 data rows.
Checking 10
The total number of data pages in this table is 1.
Table has 6 data rows.
Checking 11
The total number of data pages in this table is 1.
Checking 12
The total number of data pages in this table is 16.
Table has 744 data rows.
Checking 13
The total number of data pages in this table is 1.
Checking 14
The total number of data pages in this table is 1.
Checking 15
The total number of data pages in this table is 1.
Table has 1 data rows.
Checking 16
The total number of data pages in this table is 1.
Checking 17
The total number of data pages in this table is 1.
Checking 18
The total number of data pages in this table is 1.
Checking 30
The total number of data pages in this table is 1.
Table has 7 data rows.
Checking 31
The total number of data pages in this table is 1.
The number of rows in Sysindexes for this table was 14. It has been corrected to 13.
Table has 13 data rows.
Checking 33
The total number of data pages in this table is 1.
Table has 6 data rows.
Checking 35
The total number of data pages in this table is 1.
Table has 13 data rows.
Checking 36
The total number of data pages in this table is 101.
Table has 2191 data rows.
Checking 37
The total number of data pages in this table is 2.
Table has 53 data rows.
Checking 40
The total number of data pages in this table is 1.
Table has 1 data rows.
Checking 41
The total number of data pages in this table is 1.
Checking 44
The total number of data pages in this table is 1.
Checking 45
The total number of data pages in this table is 1.
The total number of TEXT/IMAGE pages in this table is 16.
Table has 16 data rows.
Checking 766625774
The total number of data pages in this table is 68.
Table has 2264 data rows.
Checking 1378103950
The total number of data pages in this table is 1.
Table has 8 data rows.
Checking 1410104064
The total number of data pages in this table is 2.
Table has 45 data rows.
Checking 1442104178
The total number of data pages in this table is 1.
Table has 29 data rows.
Checking 1913057851
The total number of data pages in this table is 1.
Checking 1945057965
The total number of data pages in this table is 1.
Table has 1 data rows.
Checking 1977058079
The total number of data pages in this table is 12.
Table has 486 data rows.
Checking 2025058250
The total number of data pages in this table is 1.
Checking 2057058364
The total number of data pages in this table is 1.
Checking 2089058478
The total number of data pages in this table is 1.
DBCC execution completed. If DBCC printed error messages, see your System Administrator.
把TEMPDB压缩看看
导入SQLSERVER时用你的数据库命名
第二步还原数据库
dbcc checktable('syslogs')
的结果。select * from sysobjects
where id in (3,31)
的结果。
的结果:
Checking syslogs
The total number of data pages in this table is 1.
*** NOTICE: Notification of log space used/free cannot be reported because the log segment is not on its own device.
Table has 14 data rows.
DBCC execution completed. If DBCC printed error messages, see your System Administrator.select * from sysobjects
where id in (3,31)
的结果:
name id uid type userstat sysstat indexdel schema_ver refdate crdate version deltrig instrig updtrig seltrig category cache
------------------------------ ----------- ------ ---- -------- ------- -------- ---------- --------------------------- --------------------------- ----------- ----------- ----------- ----------- ----------- ----------- ------
syscolumns 3 1 S 0 81 0 1 1900 一月 1 12:00AM 1996 四月 3 3:38AM 0 0 0 0 0 0 0
sysusages 31 1 S 0 113 0 0 1900 一月 1 12:00AM 1996 四月 3 3:38AM 0 0 0 0 0 0 0 (2 row(s) affected)
希望有好的方法,
STUDYING....
1)打开企业管理器
2)右击《数据库》
3)选择《所有任务》-〉《ATTACH DATABASE》
4)按照要求即可
最后是如何解决的,能否贴出来,我也碰到同样的问题。
我按照上面的步骤做了,最后是怎样的(看短消息那一贴)?
当时的情况好象是这样的:
我要重新装机器,把数据库文件和日志文件直接拷贝到另一台机器上去,然后重新装系统,SQL SERVER,,,等等。在Enterprise Manager里直接建数据库,名称,设备名,大小,和原来的相同,路径没关系,然后将备份的文件覆盖过来(两个),一切OK啊,而且,我干过好几次,都没问题。没这么复杂的哦。
:)
现在还没有解决,
哪儿有sql server6.5中文版的联机帮助,
看英文的太头疼了