日期:2014-05-18  浏览次数:20473 次

春暖花开,齐膝马裤妹纸跪求关于MSQL文件分组问题
是这样的,目前接手了一个数据,是带有文件分组的。
看了半天还是稀里糊涂的,跪求一些相关的资料,外求解释下这些语句,都有些什么作用。
我应该怎么去看,如果我要在另外一个服务器恢复这样的数据库的备份文件我应该怎么做。
下面是语句:
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, FIL