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

今天连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博客 ” ，链接：http://blog.itpub.net/8337095/viewspace-1033527/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8337095/viewspace-1033527/