--以下代碼簡(jiǎn)單地演示了如何進(jìn)行文件組的備份及還原（在還原時(shí)，模擬了丟失第二次文件組備份文件的情況）。
--創(chuàng)建測(cè)試數(shù)據(jù)庫(kù)
CREATE DATABASE db
ON PRIMARY(
	NAME='db_data',
	FILENAME= 'c:\db_data.mdf'),
FILEGROUP db_fg1(
	NAME = 'db_fg1_data',
	FILENAME = 'c:\db_fg1_data.ndf'),
FILEGROUP db_fg2(
	NAME = 'db_fg2_data',
	FILENAME = 'c:\db_fg2_data.ndf')
LOG ON(
	NAME='db_log',
	FILENAME ='c:\db.ldf')
GO

--在文件組db_fg1上創(chuàng)建表，并單獨(dú)創(chuàng)建該文件組的備份
CREATE TABLE db.dbo.tb(id int) ON db_fg1
BACKUP DATABASE db FILEGROUP='db_fg1' TO DISK='c:\db_fg1.bak' WITH FORMAT
GO

在其他文件組上創(chuàng)建表 
CREATE TABLE db.dbo.ta(id int) ON [PRIMARY]
CREATE TABLE db.dbo.tc(id int) ON db_fg2
INSERT db.dbo.tb SELECT id FROM sysobjects
--備份每個(gè)文件組，并且備份事務(wù)日志
BACKUP DATABASE db FILEGROUP='PRIMARY' TO DISK='c:\db_primary.bak' WITH FORMAT
BACKUP DATABASE db FILEGROUP='db_fg1' TO DISK='c:\db_fg1_new.bak' WITH FORMAT
BACKUP DATABASE db FILEGROUP='db_fg2' TO DISK='c:\db_fg2.bak' WITH FORMAT
BACKUP LOG db TO DISK='c:\db_log.bak' WITH FORMAT
GO

--刪除數(shù)據(jù)庫(kù)
DROP DATABASE db
GO

--從文件組備份中恢復(fù)數(shù)據(jù)
RESTORE DATABASE db FILEGROUP='PRIMARY' FROM DISK='c:\db_primary.bak' WITH NORECOVERY,REPLACE
RESTORE DATABASE db FILEGROUP='db_fg1' FROM DISK='c:\db_fg1.bak' WITH NORECOVERY
RESTORE DATABASE db FILEGROUP='db_fg2' FROM DISK='c:\db_fg2.bak' WITH NORECOVERY
RESTORE LOG db FROM DISK='c:\db_log.bak' WITH RECOVERY
SELECT COUNT(*) FROM db.dbo.tb
GO

--刪除測(cè)試數(shù)據(jù)庫(kù)
DROP DATABASE db