The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
3answers
4k 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
408 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
92 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
375 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
667 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
345 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
1k 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
411 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: ...
9
votes
2answers
11k 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 ...