sqlserver2000出现置疑状态的原因及解决方法
在MS SQLSERVER中一直有这样的问题,SQLSERVER的状态"置疑",我们先来分析一下SQLSERVER数据库"置疑"的原因:
1.错误的删除日志;
2.硬件(HD)损坏,造成日志和数据文件写错误;
3.硬盘的空间不够,比如日志文件过大;
解决办法:
这是最简单的办法是有数据库的全备份,然后恢复即可.
步骤:
1. 删除原始的数据库:
USE MASTER
GO
DROP DATABASE DB_SUEPECT
2.建立同名的数据库:
USE master
GO
CREATE DATABASE DB_SUSPECT
ON
( NAME = DBNAME_DAT,
FILENAME = 'C:',
SIZE = 10,
FILEGROWTH = 5 )
LOG ON
( NAME = 'DBNAME_LOG',
FILENAME = 'g:',
SIZE = 5MB,
FILEGROWTH = 5MB )
GO
3.恢复数据库:
RESTORE DATABASE DB_SUSPECT
FROM DBNAME_BACKUP.DAT
相关推荐
gaozhennan 2020-08-16
奎因amp华洛 2020-07-26
sui 2020-06-10
huanghan 2020-06-07
LzHeng 2020-06-05
maokaijiang 2020-06-05
FightFourEggs 2020-05-31
blncle 2020-05-28
踩风火轮的乌龟 2020-05-28
crowds 2020-05-06
blncle 2020-05-06
sui 2020-04-29
maokaijiang 2020-04-18
blncle 2020-04-08
maokaijiang 2020-03-27
blncle 2020-03-20