demo031.sql

来自「T-SQL示例大全」· SQL 代码 · 共 46 行

/* 文件名称: Demo031.sql */
USE master
GO

CREATE DATABASE MyDb
ON
PRIMARY ( NAME = MyDb1,
          FILENAME = 'c:\temp\MyDbdata1.mdf',
          SIZE = 10,
          MAXSIZE = 200,
          FILEGROWTH = 20),
( NAME = MyDb2,
  FILENAME = 'c:\temp\MyDbdata2.ndf',
  SIZE = 10,
  MAXSIZE = 200,
  FILEGROWTH = 20),
( NAME = MyDb3,
  FILENAME = 'c:\temp\MyDbdata3.ndf',
  SIZE = 10,
  MAXSIZE = 200,
  FILEGROWTH = 20)
LOG ON
( NAME = MyDblog1,
  FILENAME = 'c:\temp\MyDblog1.ldf',
  SIZE = 10,
  MAXSIZE = 200,
  FILEGROWTH = 20),
( NAME = MyDblog2,
  FILENAME = 'c:\temp\MyDblog2.ldf',
  SIZE = 10,
  MAXSIZE = 200,
  FILEGROWTH = 20)

GO

-- 卸离数据库 MyDb
EXEC sp_detach_db 'MyDb','true'

-- 请将数据文件与记录文件转移或复制到 d:\temp 后,执行下列命令来附加数据库
EXEC sp_attach_db @dbname = N'MyDb',
     @filename1 = N'd:\temp\MyDbdata1.mdf',
     @filename2 = N'd:\temp\MyDbdata2.ndf',
     @filename3 = N'd:\temp\MyDbdata3.ndf',
     @filename4 = N'd:\temp\MyDblog1.ldf',
     @filename5 = N'd:\temp\MyDblog2.ldf'