20CN网络安全小组论坛 - 网站建设 - MS-SQL

论坛: 网站建设标题: MS-SQL_SERVER故障求解！

作者: wordy [wordy]

论坛用户

当时现象：
1.通过网络在另外一台装Sql70 的电脑修改数据库某个表字段的宽度(CHAR(100) 变为CHAR(500)),保存
  时提示出错,接着SQL70停止服务,数据库出现SUPSECT,no item.
2. 在SQL2000
   运行命令 EXEC sp_attach_db @dbname = N'guke2',
   @filename1 = N'd:\Microsoft SQL Server\MSSQL\Data\guke2_Data.mdf',
   @filename2 = N'd:\Microsoft SQL Server\MSSQL\Data\guke2_log.ldf'
时提示出错:
服务器: 消息 3624，级别 20，状态 1，行 1

Location: q:\SPHINX\NTDBMS\storeng\drs\include\record.inl:1447

Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW

SPID: 51
Process
ID: 3364
连接中断

3.在SQL7
  运行命令
1. EXEC sp_attach_single_file_db @dbname = 'GG',
@physname = 'D:\mssql7\data\bkguke_Data.MDF'

提示:
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 8 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Server: Msg 3313, Level 21, State 2, Line 1
Error while redoing logged operation in database 'GG'. Error at log record ID (1168:184:96).

Connection Broken

2.EXEC sp_attach_db @dbname = N'GG',
@filename1 = N'D:\mssql7\data\bkguke_Data.MDF',
@filename2 = N'D:\mssql7\data\bkguke_Log.LDF'
提示:
Server: Msg 3624, Level 20, State 1, Line 1

Location: page.cpp:3151
Expression: GetPagePtr (rowPtr) == this
SPID: 8
Process
ID: -177842341

Connection Broken

地主发表时间: 05/17 18:21

回复: wang0722 [wang0722]

论坛用户

你在重装一下试试！

B1层发表时间: 12/20 16:52

论坛: 网站建设