查询分析器中执行下面的语句, 可以使库的状态变为正常.RESTORE DATABASE 库名 WITH RECOVERY
那可能是有人做了还原.也有可能是有人测试备份, 使用了类似下面这样的语句: BACKUP LOG dbname TO DISK='C:\TEST.BAK' WITH NORECOVERY
BACKUP LOG db WITH NO_LOG GO DBCC SHRINKDATABASE(db) BACKUP DATABASE [CNC_DB] TO DISK = N'S:\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\DB.bak' WITH NOFORMAT, NOINIT, NAME = N'DB-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GO 我只加入了两个Job,这样应该也没有影响的
BACKUP LOG dbname TO DISK='C:\TEST.BAK' WITH NORECOVERY
GO
DBCC SHRINKDATABASE(db)
BACKUP DATABASE [CNC_DB] TO DISK = N'S:\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\DB.bak' WITH NOFORMAT, NOINIT, NAME = N'DB-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
我只加入了两个Job,这样应该也没有影响的