数据库出问题了.

Question

sqlserver 2005 RTM 企业版

执行dbcc checkdb报错,

Msg 211, Level 23, State 51, Line 1

Possible schema corruption. Run DBCC CHECKCATALOG.

Msg 0, Level 20, State 0, Line 0

A severe error occurred on the current command.  The results, if any, should be discarded.

然后执行 DBCC CHECKCATALOG

也没什么有用的信息,只是提示什么执行完成,如果有什么错误请联系管理员之类的.

那我应该怎么解决呢?

我在本机想产生一个数据库的脚本另外建立数据库,但是根本就抓去不到物件的信息...

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 1

在2005中产生脚本的时候,提示无法读取到该数据库的物件列表.

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 2

Did you see tables in the db? Can you query them? Have good backup? Sql2k5 has sp4 for a year by the way.

Answer 3

因为现在对这个数据库进行DBCC CHECKDB的时候报错了 所以想先修复,另外新建数据库,并将数据导入过去

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 4

你看bol，里面提到了checkdb由哪几部分组成，你一个一个执行。或者checkdb的时候，用修复错误的那个参数。

---

想不想时已是想，不如不想都不想。

Answer 5

修复前,最好对MDF,NDF和LDF文件冷备份下,万一修复失败,还可以找找其他途径解决!

---

胡冰

Answer 6

Wish sql can bring that db online after restarting.

Answer 7

Did you see tables in the db? Can you query them? Have good backup? Sql2k5 has sp4 for a year by the way.

可以在ssms中看到有那个表.

但是执行select * from sysobjects where name='xx'找不到任何信息

这个数据库中大部分的表都可以执行

但是有几个表一执行查询操作,就报错:物件不存在

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 8

You meant "select * from sys.objects where name='xx'" or "select * from sys.sysobjects where name='xx'"? Your permission in that db?

Answer 9

You meant "select * from sys.objects where name='xx'" or "select * from sys.sysobjects where name='xx'"? Your permission in that db?

是的.

我的是sysadmin权限的.

但是在SSMS中表节点下可以看到那个表,而且右键点击open也是可以看到数据的.

但是在命令行窗口执行select就报错invalid object

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 10

Which schema is the table in? Can you post your query against that table?