Question : Is there a way to automatically move clustered indexes A on one filegroup, and all nonclustered indexes to […]
Tag: filegroups
How can I backup & restore a single FILEGROUP in Sql Server 2008
Question : Previously, on ServerFault I asked a question about backing up and restoring a Sql Server 2008 Filegroup. Today, […]
On which filegroup will constraints be created by default when adding them to a table on a filegroup and how should they be separeated?
Question : We have multiple filegroups, that look something like this: PRIMARY (default) app_data app_index When I create a table […]
How to restore a file group from file group backup?
Question : I want to restore a specific file group from file group backup. I found examples how to restore […]
PRIMARY’ filegroup is full [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Partition : understanding files and file groups
Question : We are trying to partition a large history table. Being new to partitioning, I was trying to understand […]
File Group Association while Snapshop Replication
Question : I want to know how can I save filegroup structure during snapshop replication in SQL Server? Does this […]
Multiple filegroups vs. multiple files in a single filegroup
Question : From what I’ve read online, it seems that multiple filegroups offer only two advantages over having multiple files […]
What happens when you create the primary key of a table on a different filegroup?
Question : Creating a table on a different filegroup is absolutely no problem when using Sql Server. create table common.test […]
Does spreading table data across multiple files (in the filegroup) improve performance?
Question : From the product documentation on filegroups: For example: Data1.ndf, Data2.ndf, and Data3.ndf, can be created on three disk […]