数据库变为置疑,可能是日志文件损坏造成的,有无办法恢复?
pgpga 2004-12-01 08:36:10 以前运行正常的数据库,突然变为置疑。而磁盘空间还很大,我怀疑是日志文件损坏造成的。
数据库数据文件picturedata.mdf,picture1.ndf,picture2.ndf,日志文件picturelog.ldf,
建库sql为:
USE master
GO
CREATE DATABASE PICTURE
ON PRIMARY
( NAME = PICTURE_Data,
FILENAME = 'K:\DB Files\picturedata.mdf',
SIZE = 10,
MAXSIZE = 500,
FILEGROWTH = 5 ),
FILEGROUP SECONDARY
( NAME = PICTURE_1,
FILENAME = 'K:\DB Files\picture1.ndf',
SIZE = 10,
MAXSIZE = 500,
FILEGROWTH = 5),
( NAME = PICTURE_2,
FILENAME = 'K:\DB Files\picture2.ndf',
SIZE = 10,
MAXSIZE = 500,
FILEGROWTH = 5)
LOG ON
( NAME = PICTURE_Log,
FILENAME = 'K:\DB Files\picturelog.ldf',
SIZE = 5,
MAXSIZE = 400,
FILEGROWTH = 5 )
COLLATE Chinese_PRC_CS_AS
GO
EXEC sp_addlogin 'TPU', 'renzheng', 'PICTURE', 'Simplified Chinese'
EXEC sp_addsrvrolemember 'TPU', 'dbcreator'
USE PICTURE
GO
EXEC sp_changedbowner 'TPU'
EXEC sp_grantdbaccess guest
我试过有关解决置疑问题的帖子中的方法,都不行。我的数据库为sql server2000请各位指点。