i

介绍了数据库方面的基础知识

作者：adam.zhu
email: [e-mail]
日期：2001-7-4 11:13:46
具体的你可以看BOOK ON LINE，在里面检索SUSPECT。我简单给大家列一下步骤。这个方法主要是调用了sp_resetstatus 存储过程，在6。5版本里需要在MASTER数据库中建立这个存储过程，在6。5以后版本直接运行sp_resetstatus 这个存储过程。
第一步：
USE master
GO
sp_configure 'allow updates', 1
GO
RECONFIGURE WITH OVERRIDE
GO
第二步：
CREATE PROC sp_resetstatus @dbname varchar(30) AS

DECLARE @msg varchar(80)

IF @@trancount > 0

        BEGIN

            PRINT "Can't run sp_resetstatus from within a transaction."

            RETURN (1)

        END

IF suser_id() != 1

        BEGIN

            SELECT @msg =  "You must be the System Administrator (SA)"

            SELECT @msg = @msg + " to execute this procedure."

            RETURN (1)

        END

IF (SELECT COUNT(*) FROM master..sysdatabases

            WHERE name = @dbname) != 1

        BEGIN

            SELECT @msg = "Database '" + @dbname + "' does not exist!"

            PRINT @msg

            RETURN (1)

        END

IF (SELECT COUNT(*) FROM master..sysdatabases

            WHERE name = @dbname AND status & 256 = 256) != 1

        BEGIN

            PRINT "sp_resetstatus can only be run on suspect databases."

            RETURN (1)

        END

BEGIN TRAN

        UPDATE master..sysdatabases SET status = status ^ 256

            WHERE name = @dbname

        IF @@error != 0 OR @@rowcount != 1

            ROLLBACK TRAN

        ELSE 

            BEGIN

                COMMIT TRAN

                SELECT @msg = "Database '" + @dbname + "' status reset!"

                PRINT @msg

                PRINT " " 
                PRINT "WARNING: You must reboot SQL     Server prior to  "

                PRINT "         accessing this database!"

                PRINT " "

            END

  

GO
第三步：
sp_configure 'allow updates', 0

GO

RECONFIGURE WITH OVERRIDE

GO
第四步：
exec sp_resetstatus '出错的数据库名字'