如何创建sqlserver 数据库(0002)

最新推荐文章于 2022-03-28 12:16:08 发布

rfq

最新推荐文章于 2022-03-28 12:16:08 发布

阅读量1.4k

点赞数

分类专栏： sqlserver数据库文章标签：数据库 sqlserver database archive 服务器 disk

本文链接：https://blog.csdn.net/rfq/article/details/1328844

版权

sqlserver数据库专栏收录该内容

7 篇文章 0 订阅

订阅专栏

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