开发学院数据库MySQL 在附加多个.MDF文件时重新建立日志 阅读

在附加多个.MDF文件时重新建立日志

 2010-06-21 00:00:00 来源:WEB开发网   
核心提示:现在让我们假设我们已经有了一个数据库叫MyDB1,它有18个.MDF文件和17个.LDF文件,在附加多个.MDF文件时重新建立日志,执行下面的命令,USE[master] GO /**Object:Database[MyDB1]ScriptDate:08/11/200911:54:20**/ IFEXISTS(SELE

现在让我们假设我们已经有了一个数据库叫MyDB1,它有18个.MDF文件和17个.LDF文件。执行下面的命令。

USE [master]
  GO
  /****** Object: Database [MyDB1] Script Date: 08/11/2009 11:54:20 ******/
  IF EXISTS (SELECT name FROM sys.databases WHERE name = N'MyDB1')
  DROP DATABASE [MyDB1]
  GO
  CREATE DATABASE MyDB1
  ON
  ( NAME = MyDB1_dat1,FILENAME = 'C:\Data\MyDB1.mdf'),
  ( NAME = MyDB1_dat2,FILENAME = 'C:\Data\MyDB2.mdf'),
  ( NAME = MyDB1_dat3,FILENAME = 'C:\Data\MyDB3.mdf'),
  ( NAME = MyDB1_dat4,FILENAME = 'C:\Data\MyDB4.mdf'),
  ( NAME = MyDB1_dat5,FILENAME = 'C:\Data\MyDB5.mdf'),
  ( NAME = MyDB1_dat6,FILENAME = 'C:\Data\MyDB6.mdf'),
  ( NAME = MyDB1_dat7,FILENAME = 'C:\Data\MyDB7.mdf'),
  ( NAME = MyDB1_dat8,FILENAME = 'C:\Data\MyDB8.mdf'),
  ( NAME = MyDB1_dat9,FILENAME = 'C:\Data\MyDB9.mdf'),
  ( NAME = MyDB1_dat10,FILENAME = 'C:\Data\MyDB10.mdf'),
  ( NAME = MyDB1_dat11,FILENAME = 'C:\Data\MyDB11.mdf'),
  ( NAME = MyDB1_dat12,FILENAME = 'C:\Data\MyDB12.mdf'),
  ( NAME = MyDB1_dat13,FILENAME = 'C:\Data\MyDB13.mdf'),
  ( NAME = MyDB1_dat14,FILENAME = 'C:\Data\MyDB14.mdf'),
  ( NAME = MyDB1_dat15,FILENAME = 'C:\Data\MyDB15.mdf'),
  ( NAME = MyDB1_dat16,FILENAME = 'C:\Data\MyDB16.mdf'),
  ( NAME = MyDB1_dat17,FILENAME = 'C:\Data\MyDB17.mdf'),
  ( NAME = MyDB1_dat18,FILENAME = 'C:\Data\MyDB18.mdf')
  LOG ON
  ( NAME = MyDB1_log1,FILENAME = 'C:\Data\MyDB1.ldf'),
  ( NAME = MyDB1_log2,FILENAME = 'C:\Data\MyDB2.ldf'),
  ( NAME = MyDB1_log3,FILENAME = 'C:\Data\MyDB3.ldf'),
  ( NAME = MyDB1_log4,FILENAME = 'C:\Data\MyDB4.ldf'),
  ( NAME = MyDB1_log5,FILENAME = 'C:\Data\MyDB5.ldf'),
  ( NAME = MyDB1_log6,FILENAME = 'C:\Data\MyDB6.ldf'),
  ( NAME = MyDB1_log7,FILENAME = 'C:\Data\MyDB7.ldf'),
  ( NAME = MyDB1_log8,FILENAME = 'C:\Data\MyDB8.ldf'),
  ( NAME = MyDB1_log9,FILENAME = 'C:\Data\MyDB9.ldf'),
  ( NAME = MyDB1_log10,FILENAME = 'C:\Data\MyDB10.ldf'),
  ( NAME = MyDB1_log11,FILENAME = 'C:\Data\MyDB11.ldf'),
  ( NAME = MyDB1_log12,FILENAME = 'C:\Data\MyDB12.ldf'),
  ( NAME = MyDB1_log13,FILENAME = 'C:\Data\MyDB13.ldf'),
  ( NAME = MyDB1_log14,FILENAME = 'C:\Data\MyDB14.ldf'),
  ( NAME = MyDB1_log15,FILENAME = 'C:\Data\MyDB15.ldf'),
  ( NAME = MyDB1_log16,FILENAME = 'C:\Data\MyDB16.ldf'),
  ( NAME = MyDB1_log17,FILENAME = 'C:\Data\MyDB17.ldf')
  GO

1 2 3 4  下一页

Tags:附加 多个 MDF

编辑录入:爽爽 [复制链接] [打 印]
[]
  • 好
  • 好的评价 如果觉得好,就请您
      0%(0)
  • 差
  • 差的评价 如果觉得差,就请您
      0%(0)
更多精彩
    赞助商链接

    热点阅读
      焦点图片
        最新推荐
          精彩阅读