TRY:
USE MASTER
GO
SP_CONFIGURE 'ALLOW UPDATE',1
GO
RECONFIGURE WITH OVERRIDE
GO
SP_RESETSTATUS
GO
SP_CONFIGURE 'ALLOW UPDATE',0
GO
RECONFIGURE WITH OVERRIDE
GO
USE MASTER
GO
SP_CONFIGURE 'ALLOW UPDATE',1
GO
RECONFIGURE WITH OVERRIDE
GO
SP_RESETSTATUS
GO
SP_CONFIGURE 'ALLOW UPDATE',0
GO
RECONFIGURE WITH OVERRIDE
GO
解决方案 »
- TA们说,开贴名字叫‘小女子冰天雪地跪求vb考勤管理系统源码’
- sqlserver中有没有像oracle那样的分析函数(lead,lag),可以取上一行,下一行的数据
- SQL SERVER 2005 装完后为什么没有服务
- 请教一个排序问题!
- 怎么批量删除整个库中表内相同的内容
- 怎么得到某个日期是星期几
- 求SQL语句(必结贴)
- sql7.0中一user庫的Stored Procedures中執行master庫的stored procedure如何寫?
- 我怎么一安装SQL Server2000就失败,提示“安装程序”配置服务器失败......"?
- 请问:执行时间比较长的存储过程的问题
- 我用sp_helpserver为什么不能显示多个server?
- 想不通: 全文索引怎么不支持左侧通配符呢? 例如: 我想查询所有4558的IC, 但是
The database is ed as suspect because it failed the recovery process that brings a database to a consistent transactional state. This can occur during the following operations: Starting up an instance of Microsoft® SQL Server™ 2000.
Attaching a database.
Using the RESTORE database or RESTORE LOG procedures.
Action
Inspect the Microsoft SQL Server error log and determine the cause of the error. If SQL Server has been restarted since the failed recovery, look at previous SQL Server error logs to see the reason why recovery failed. If the recovery failed because of a persistent I/O error, a torn page, or other possible hardware problem, resolve the underlying hardware problem and restore the database by using a backup. If no backups are available, consider the repair options of DBCC CHECKDB.If you are unable to resolve this problem, contact your primary support provider. Have the SQL Server error log available for review.
/*
Prior to updating sysdatabases entry for database 'msdb', mode = 0 and status = 280 (status suspect_bit = 256).
For row in sysdatabases for database 'msdb', the status bit 256 was forced off and mode was forced to 0.
Warning: You must recover this database prior to access.
*/
出現以上提示 ﹐什么意思?
先执行:
USE master
GO
sp_configure 'allow updates', 1
GO
RECONFIGURE WITH OVERRIDE
GO
使系统表可写
然后执行:
UPDATE master.dbo.sysdatabases SET status = status ^ 256
WHERE name = 你的数据库名
或者
sp_resetstatus 你的数据库名
最后执行:
sp_configure 'allow updates', 0
GO
RECONFIGURE WITH OVERRIDE
GO
你应该安我的STEP来操作,首先要配置
SP_CONFIGURE 'ALLOW UPDATE',1
Error 926: Database 'msdb' cannot be opened . It has been ed SUSPECT by recovery . See the SQL Server errorlog for more information.這是為什么?
早上上班時我打開SQL SERVER Enterprise Manager時發現我的msdb數據庫被置疑,同時也打不開。
后來按 'leimin' 的方法做后﹐msdb數據庫可以打開﹐顯示表﹐視圖之類的﹐但想打開表﹐視圖時卻又出現以下錯誤提示﹕
Error 926: Database 'msdb' cannot be opened . It has been ed SUSPECT by recovery . See the SQL Server errorlog for more information. 請高手相助﹐幫忙解決!!! 如能解釋為何會出現這種問題﹐更好﹗﹗﹗ 分不夠 可以再加﹗﹗﹗﹗
DBCC CHECKDB检测数据库的问题.
2.用最新的BACKUP恢复一下也可以.我后面不是贴了一段MS的解释么?你仔细看看,一定会有帮助.
另我用以下語句也不可以﹕use msdb
godbcc checkdb
go因為我的這個數據庫沒有備份, 除了恢復有沒有別的辦法。 要沒我可就殘了!!!!
多謝各位!!!!!
FIRST STOP ANS RESTART MS SQL SERVER SERVICE,AND YOU MUST STOP MS SQL SERVERAGENT SEVICE!
THEN RUN USE MASER
GO
SP_DETACH_DB 'MSDB'
GOCOPY THE MSDBDATA.MDF AND MSDBLOG.LDF TO A OTHER PATTATION LIKE DUSE MASTER
GO
SP_ATTACH_DB 'MSDB','D:\MSDBDATA.MDF','MSDBLOG.LDF'
GOTHEN RUN THE ABOVE SCRIPT AGAIN!
27 transactions rolled forward in database 'msdbtest' (13).
Location: q:\SPHINX\NTDBMS\storeng\drs\include\record.inl:1447
Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
SPID: 55
Process ID: 760Connection Broken