免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1052 | 回复: 1

alter 错误,请指教,急~~ [复制链接]

论坛徽章:
0
发表于 2003-12-04 12:05 |显示全部楼层
当我alter一个数据库时,它提示下面的错误,请问这个是什么意思,如何修复?

1>; alter database acct on datdev2 = 1000
2>;
3>; go
Extending database by 512000 pages on disk datdev2
Msg 692, Level 20, State 1:
Server 'PAFDOM', Line 1:
Uninitialized logical page '120' was read while accessing object '7' in database
'16'. Please contact Sybase Technical Support.
The SQL Server is terminating this process.
as:root /  13 >;

论坛徽章:
1
2017金鸡报晓
日期:2017-01-10 15:19:56
发表于 2003-12-04 13:23 |显示全部楼层

alter 错误,请指教,急~~

1 Check the server error log for other errors that may have been raised prior
to the 692 error. Save the entire error log.
2 Obtain page information by running dbcc page as soon as possible, using
the database ID and page number shown in the message:
1>; dbcc page (<db_id>;, <page_number>;, 0, 1, 1, -1)
2>; go
3 Identify the object named in the error message using the following isql
commands:
1>; use <database name>;
2>; go
1>; select name from sysobjects where id=<object_id>;
2>; go
4 Find information about this object in sysindexes:
1>; select first, root, doampg, ioampg from sysindexes
2>; where name = object_name(<object_id>
3>; go
5 To determine the full extent of the corruption, run dbcc checkstorage, the
dbcc checkdb and dbcc checkalloc commands, or dbcc checktable and dbcc
tablealloc) as soon as possible.
6 To check if this error is a result of hardware failure, examine your
operating system error log and correct hardware problems. See “Checking
the Operating System Error Log” in the Encyclopedia of Tasks chapter for
assistance.
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP