如何创建sqlserver 数据库(0002)

来源：互联网发布：淘宝卖电影票货源编辑：程序博客网时间：2024/05/12 05:42

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