sqlServer创建数据库并指定mdf,ldf文件所在路径
CREATE DATABASE [dataBaseName]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'student_manage', FILENAME = N'D:\dataBaseName.mdf' ,
SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
LOG ON
( NAME = N'student_manage_log', FILENAME = N'D:\dataBaseName.ldf' ,
SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
WITH CATALOG_COLLATION = DATABASE_DEFAULT