今天连db结果遇到如下错误：

SQL SERVER – FIX : Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details

第一直觉就是dbf的权限问题，一查果然。。。。

由于空间不够

还顺便把dbf文件移动了下
再attach上
sql模板如下：

CREATE DATABASE [ALS_LFE] ON PRIMARY
( NAME = N'DXXXXXXXXXXXXXXXXX', FILENAME = N'DXXXXXXXXXXXXXXXXX.mdf' , MAXSIZE = XXXXKB, FILEGROWTH = XXXXKB )
LOG ON
( NAME = N'DXXXXXXXXXXXXXXXXX_log', FILENAME = N'DXXXXXXXXXXXXXXXXX.ldf' ,MAXSIZE = UNLIMITED , FILEGROWTH = 10%)
FOR ATTACH
GO

[@more@]

ITPub博客

Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space

最新文章