USE test
GO
ALTER DATABASE test
MODIFY FILE
(
NAME='D:\XP\SQLDB\test.mdf',
SIZE=20MB
)
问题是:(MODIFY FILE 失败。文件 'D:\XP\SQLDB\test.mdf' 不存在。)
解决:
USE test
GO
ALTER DATABASE test
MODIFY FILE
(
filename='D:\XP\SQLDB\test.mdf',
name='test',
SIZE=20MB
)