Sql Server 脚本创建新的数据库

基中dbname替换成你的数据库实例名称 D:\tools\SqlServer\MSSQL\DATA\替换成文件保存的实际路径

--创建数据库
USE master;
GO
CREATE DATABASE dbname
ON
( NAME = dbname_dat,
    FILENAME = 'D:\tools\SqlServer\MSSQL\DATA\dbname.mdf',
    SIZE = 10,
    MAXSIZE = 50,
    FILEGROWTH = 5 )
LOG ON
( NAME = dbname_log,
    FILENAME = 'D:\tools\SqlServer\MSSQL\DATA\dbname.ldf',
    SIZE = 5MB,
    MAXSIZE = 25MB,
    FILEGROWTH = 5MB );
GO

-- SQL Server 登录名
CREATE LOGIN dbname
    WITH PASSWORD = 'wisdom@2021';
--创建数据库用户
CREATE USER dbname FOR LOGIN dbname;
GO