1、简单创建数据库[数据库路径在:服务器属性-〉数据库设置选项卡->新数据默认位置]
create database [dbname]
2、恢复备份文件到新的数据库名称,并且指定数据文件和日志文件的路径
exec( 'RESTORE DATABASE '+@newName+'
FROM DISK = '''+@TempPath+''',
MOVE '''+@logicalname_db+''' TO ''D:/Reco/Data/'+@newName+'.MDF'',
MOVE '''+@logicalname_log+''' TO ''D:/Reco/Data/'+@newName+'.LDF''')
3、指定多个数据文件和事务日志文件创建数据库
CREATE DATABASE Archive
ON
PRIMARY ( NAME = Arch1,
FILENAME = 'c:/program files/microsoft sql server/mssql/data/archdat1.mdf',
SIZE = 100MB,
MAXSIZE = 200,
FILEGROWTH = 20),
( NAME = Arch2,
FILENAME = 'c:/program files/microsoft sql server/mssql/data/archdat2.ndf',
SIZE = 100MB,
MAXSIZE = 200,
FILEGROWTH = 20),
( NAME = Arch3,
FILENAME = 'c:/program files/microsoft sql server/mssql/data/archdat3.ndf',
SIZE = 100MB,
MAXSIZE = 200,
FILEGROWTH = 20)
LOG ON
( NAME = Archlog1,
FILENAME = 'c:/program files/microsoft sql server/mssql/data/archlog1.ldf',
SIZE = 100MB,
MAXSIZE = 200,
FILEGROWTH = 20),
( NAME = Archlog2,
FILENAME = 'c:/program files/microsoft sql server/mssql/data/archlog2.ldf',
SIZE = 100MB,
MAXSIZE = 200,
FILEGROWTH = 20)
GO