The filegroups tag has no wiki summary.
2
votes
3answers
2k views
Filegroup cannot be removed because it is not empty error with no files
When I try to remove 'MYFILEGROUP', I get the error that the filegroup cannot be removed because it is not empty. I already removed all tables, indexes and deleted all files associated with the group. ...
0
votes
1answer
300 views
Advantages of multiple SQL Server files with a single RAID array
Originally posted on stack overflow, but re-worded.
Imagine the scenario : For a database I have RAID arrays R: (MDF) T: (transaction log) and of course shared transparent usage of X: (tempDB).
I've ...
0
votes
1answer
86 views
SQL Server 2008 table with multiple Filegroups
Is this possible? I have never seen it before but recently came into running some servers where the application/service creates a new data file and new data filegroup every week. Beyond the absurdity ...
0
votes
1answer
339 views
Putting indexes in separate filegroup kills our queries
Can anyone shed some light on this?
On our dev boxes, our database resides entirely in the PRIMARY filegroup, and everything works fine.
On one of our production servers, recently upgraded from 2005 ...
0
votes
3answers
567 views
Optimal setup of files, filegroups and RAID types for a large Microsoft SQL Server Database
First - while I'd totally be down for advice; I'm also interested if there are any good ways of measuring/collecting data in advance that I could use to determine which 'rules of thumb' to follow and ...
1
vote
1answer
328 views
SQL restore from single file db to filegroup
I have a 180GB MOSS 2007 database whose maintenance (i.e. backups and restores) are becoming a problem. Part of the issue can be resolved by splitting the three content sites down into their own site ...
0
votes
1answer
981 views
After adding data files to a file group Is there a way to distribute the data into the new files?
I have a database in a single file group, with a single file group. I've added 7 data files to this file group. Is there a way to rebalance the data over the 8 data files other than by telling sql ...
1
vote
2answers
1k views
SQL Server 2005 standard filegroups / files for performance on SAN
I submitted this to stack overflow (here) but realised it should really be on serverfault. so apologies for the incorrect and duplicate posting:
Ok so I've just been on a SQL Server course and we ...
2
votes
2answers
1k views
SQLServer Split Database File and FileGroups
I'm a software developer, but this month I've to do some db admin tasks. I've some knowledge gaps about how to split the database, here my first aproach:
FileGroup for a tables
FileGroup for a ...
0
votes
1answer
332 views
file system not supported error while adding a file to sql filegroup with filestream
hi
i am a beginner with sql server 2008, i was trying to add a file to a filegroup so that i an create a table which uses filestream, but i keep getting an errors.
here is the code that i am trying:
...
8
votes
2answers
10k views
SQL Server 2005 / 2008 - multiple files / filegroups - how many? Why?
I'm a developer at heart - but every now and then, a customer doesn't have a decent DBA to deal with these issues, so I'm called in to decide....
What are your strategies / best practices when it ...
9
votes
3answers
4k views
In SQL Server, when should you split your PRIMARY Data FileGroup into secondary data files?
Our database currently only has one FileGroup, PRIMARY, which contains roughly 8GB of data (table rows, indexes, full-text catalog).
When is a good time to split this into secondary data files? What ...
