SQL Server - 文件组，文件，备份，分区
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了SQL Server - 文件组，文件，备份，分区，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含3631字，纯文字阅读大概需要6分钟。
内容图文
FileGroup：文件组，为逻辑划分；Files：文件，为实际文件，需要指定文件属于哪个文件组。
使用多个文件的有点：可以将磁盘I/O压力分散，提供按文件和文件组（按文件和文件组进行备份需要设置数据的恢复模式为Full）进行备份。
--
创建文件组
USE
[
master
]
GO
ALTER
DATABASE
[
DWH_Optimizing
]
ADD FILEGROUP [DWH_Optimizing_1]GOALTERDATABASE[DWH_Optimizing]ADD FILEGROUP [DWH_Optimizing_2]GOALTERDATABASE[DWH_Optimizing]ADD FILEGROUP [DWH_Optimizing_3]GOALTERDATABASE[DWH_Optimizing]ADD FILEGROUP [DWH_Optimizing_4]GO--创建文件USE[master]GOALTERDATABASE[DWH_Optimizing]ADDFILE ( NAME = N‘DWH_Optimizing_11‘, FILENAME = N‘E:\MSSQL11.BIS01\MSSQL\DATA\DWH_Optimizing_11.ndf‘ , SIZE = 512000KB , FILEGROWTH =50%) TO FILEGROUP [DWH_Optimizing_1]GOALTERDATABASE[DWH_Optimizing]ADDFILE ( NAME = N‘DWH_Optimizing_12‘, FILENAME = N‘E:\MSSQL11.BIS01\MSSQL\DATA\DWH_Optimizing_12.ndf‘ , SIZE = 512000KB , FILEGROWTH =50%) TO FILEGROUP [DWH_Optimizing_1]GOALTERDATABASE[DWH_Optimizing]ADDFILE ( NAME = N‘DWH_Optimizing_21‘, FILENAME = N‘E:\MSSQL11.BIS01\MSSQL\DATA\DWH_Optimizing_21.ndf‘ , SIZE = 512000KB , FILEGROWTH =50%) TO FILEGROUP [DWH_Optimizing_2]GOALTERDATABASE[DWH_Optimizing]ADDFILE ( NAME = N‘DWH_Optimizing_22‘, FILENAME = N‘E:\MSSQL11.BIS01\MSSQL\DATA\DWH_Optimizing_22.ndf‘ , SIZE = 512000KB , FILEGROWTH =50%) TO FILEGROUP [DWH_Optimizing_2]GOALTERDATABASE[DWH_Optimizing]ADDFILE ( NAME = N‘DWH_Optimizing_31‘, FILENAME = N‘E:\MSSQL11.BIS01\MSSQL\DATA\DWH_Optimizing_31.ndf‘ , SIZE = 512000KB , FILEGROWTH =50%) TO FILEGROUP [DWH_Optimizing_3]GOALTERDATABASE[DWH_Optimizing]ADDFILE ( NAME = N‘DWH_Optimizing_32‘, FILENAME = N‘E:\MSSQL11.BIS01\MSSQL\DATA\DWH_Optimizing_32.ndf‘ , SIZE = 512000KB , FILEGROWTH =50%) TO FILEGROUP [DWH_Optimizing_3]GOALTERDATABASE[DWH_Optimizing]ADDFILE ( NAME = N‘DWH_Optimizing_41‘, FILENAME = N‘E:\MSSQL11.BIS01\MSSQL\DATA\DWH_Optimizing_41.ndf‘ , SIZE = 512000KB , FILEGROWTH =50%) TO FILEGROUP [DWH_Optimizing_4]GOALTERDATABASE[DWH_Optimizing]ADDFILE ( NAME = N‘DWH_Optimizing_42‘, FILENAME = N‘E:\MSSQL11.BIS01\MSSQL\DATA\DWH_Optimizing_42.ndf‘ , SIZE = 512000KB , FILEGROWTH =50%) TO FILEGROUP [DWH_Optimizing_4]GOALTERDATABASE[DWH_Optimizing] MODIFY FILE ( NAME = N‘DWH_Optimizing_log‘, MAXSIZE = UNLIMITED)
GO
备份：完整备份，差异备份，文件、文件组和日志备份（需要设置数据的恢复模式为Full）
--
文件组备份
BACKUP
DATABASE
[
DWH_Optimizing
] FILEGROUP = N‘DWH_Optimizing_1‘TODISK= N‘F:\MSSQL11.BIS01\MSSQL\Backup\DWH_Optimizing.bak‘WITH NOFORMAT, NOINIT, NAME = N‘DWH_Optimizing-Full Filegroup Backup‘, SKIP, NOREWIND, NOUNLOAD, STATS =10GO--文件备份BACKUPDATABASE[DWH_Optimizing]FILE= N‘DWH_Optimizing_11‘TODISK= N‘F:\MSSQL11.BIS01\MSSQL\Backup\DWH_Optimizing.bak‘WITH NOFORMAT, NOINIT, NAME = N‘DWH_Optimizing-Full File Backup‘, SKIP, NOREWIND, NOUNLOAD, STATS =10GO--完整备份BACKUPDATABASE[DWH_Optimizing]TODISK= N‘F:\MSSQL11.BIS01\MSSQL\Backup\DWH_Optimizing.bak‘WITH NOFORMAT, NOINIT, NAME = N‘DWH_Optimizing-Full Database Backup‘, SKIP, NOREWIND, NOUNLOAD, STATS =10GO--差异备份BACKUPDATABASE[DWH_Optimizing]TODISK= N‘F:\MSSQL11.BIS01\MSSQL\Backup\DWH_Optimizing.bak‘WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N‘DWH_Optimizing-Differential Database Backup‘, SKIP, NOREWIND, NOUNLOAD, STATS =10GO--事物日志备份BACKUPLOG[DWH_Optimizing]TODISK= N‘F:\MSSQL11.BIS01\MSSQL\Backup\DWH_Optimizing.bak‘WITH NOFORMAT, NOINIT, NAME = N‘DWH_Optimizing-Transaction Log Backup‘, SKIP, NOREWIND, NOUNLOAD, STATS =10GO
分区，可以将表按照某个字段进行分区
--
创建分区函数
CREATE PARTITION FUNCTION[PF_BICompany](int) AS RANGE RIGHTFORVALUES (2, 3, 4, 5)
GO--创建分区架构CREATE PARTITION SCHEME [PS_BICompany]AS PARTITION [PF_BICompany]TO ([DWH_Optimizing_1], [DWH_Optimizing_2], [DWH_Optimizing_3], [DWH_Optimizing_4], [PRIMARY])
GO
原文：http://www.cnblogs.com/Niko12230/p/6780937.html
内容总结
以上是互联网集市为您收集整理的SQL Server - 文件组，文件，备份，分区全部内容，希望文章能够帮你解决SQL Server - 文件组，文件，备份，分区所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。
来源：【匿名】