sql-server - 在默认路径中创建数据库

Question

我有简单的代码

: CREATE DATABASE [asst]  
: ON (NAME = 'asst_dat', FILENAME = 'C:\data' , SIZE = 62, FILEGROWTH = 10%) 
: LOG ON (NAME = 'asst_log', FILENAME = 'C:\data' , SIZE = 146, FILEGROWTH = 10%)

如何更改 FILENAME 参数以在默认安装路径(如 C:\Program Files\Microsoft SQL Server\MSSQL10_50.ATASSIST\MSSQL)中创建数据库。那么为什么我需要它:从版本到版本，从 SQL Server 实例到实例，这个位置都不同

Answer 1

首先创建数据库，然后根据需要更改文件属性。

CREATE DATABASE [DBName]
GO

ALTER DATABASE [DBName] MODIFY FILE
( NAME = N'DBName' , SIZE = 512MB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
GO

ALTER DATABASE [DBName] MODIFY FILE
( NAME = N'DBName_log' , SIZE = 256MB , MAXSIZE = UNLIMITED , FILEGROWTH = 10%)
GO