是这样的,目前接手了一个数据,是带有文件分组的。
看了半天还是稀里糊涂的,跪求一些相关的资料,外求解释下这些语句,都有些什么作用。
我应该怎么去看,如果我要在另外一个服务器恢复这样的数据库的备份文件我应该怎么做。
下面是语句:
USE [master]
GO
/****** Object: Database [MDATA] Script Date: 03/20/2012 15:02:04 ******/
CREATE DATABASE [MDATA] ON PRIMARY
( NAME = N'MDATA', FILENAME = N'F:\DataFile\MDATA.mdf' , SIZE = 148009920KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ),
FILEGROUP [MDATA201001]
( NAME = N'MDATA201001', FILENAME = N'F:\DataFile\MDATA201001.ndf' , SIZE = 1351488KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
FILEGROUP [MDATA201002]
( NAME = N'MDATA201002', FILENAME = N'F:\DataFile\MDATA201002.ndf' , SIZE = 1200384KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
FILEGROUP [MDATA201003]
( NAME = N'MDATA201003', FILENAME = N'F:\DataFile\MDATA201003.ndf' , SIZE = 1339136KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
FILEGROUP [MDATA201004]
( NAME = N'MDATA201004', FILENAME = N'F:\DataFile\MDATA201004.ndf' , SIZE = 1346880KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
FILEGROUP [MDATA201005]
( NAME = N'MDATA201005', FILENAME = N'F:\DataFile\MDATA201005.ndf' , SIZE = 4130112KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
FILEGROUP [MDATA201006]
( NAME = N'MDATA201006', FILENAME = N'F:\DataFile\MDATA201006.ndf' , SIZE = 1406592KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
FILEGROUP [MDATA201007]
( NAME = N'MDATA201007', FILENAME = N'F:\DataFile\MDATA201007.ndf' , SIZE = 1420160KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
FILEGROUP [MDATA201008]
( NAME = N'MDATA201008', FILENAME = N'F:\DataFile\MDATA201008.ndf' , SIZE = 7667584KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
FILEGROUP [MDATA201101]
( NAME = N'MDATA201101', FILENAME = N'F:\DataFile\MDATA201101.ndf' , SIZE = 1667520KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
FILEGROUP [MDATA201102]
( NAME = N'MDATA201102', FILENAME = N'F:\DataFile\MDATA201102.ndf' , SIZE = 1529600KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
FILEGROUP [MDATA201103]
( NAME = N'MDATA201103', FILENAME = N'F:\DataFile\MDATA201103.ndf' , SIZE = 1746176KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
FILEGROUP [MDATA201104]
( NAME = N'MDATA201104', FILENAME = N'F:\DataFile\MDATA201104.ndf' , SIZE = 1704576KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
FILEGROUP [MDATA201105]
( NAME = N'MDATA201105', FILENAME = N'F:\DataFile\MDATA201105.ndf' , SIZE = 7635648KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
FILEGROUP [MDATA201106]
( NAME = N'MDATA201106', FILENAME = N'F:\DataFile\MDATA201106.ndf' , SIZE = 7114944KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
FILEGROUP [MDATA201107]
( NAME = N'MDATA201107', FILENAME = N'F:\DataFile\MDATA201107.ndf' , SIZE = 7900416KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
FILEGROUP [MDATA201108]
( NAME = N'MDATA201108', FILENAME = N'F:\DataFile\MDATA201108.ndf' , SIZE = 9269632KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
FILEGROUP [MDATA201109]
( NAME = N'MDATA201109', FILENAME = N'F:\DataFile\MDATA201109.ndf' , SIZE = 9299456KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
FILEGROUP [MDATA201110]
( NAME = N'MDATA201110', FILENAME = N'F:\DataFile\MDATA201110.ndf' , SIZE = 9960576KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
FILEGROUP [MDATA201111]
( NAME = N'MDATA201111', FILENAME = N'F:\DataFile\MDATA201111.ndf' , SIZE = 9987136KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
FILEGROUP [MDATA201112]
( NAME = N'MDATA201112', FILENAME = N'F:\DataFile\MDATA201112.ndf' , SIZE = 10393600KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),