MSSQLTips.com - your daily source for SQL Server tips

Google
 
Web mssqltips.com

ESSENTIALS: Home | Tips | Search | Categories | Top 10 | Products | Authors | Blogs | Forums | Webcasts | Advertise | About
Using Multiple Filegroups in a SQL Server Database -

in Search

Using Multiple Filegroups in a SQL Server Database

Last post 06-24-2008 11:21 AM by kdsturg51. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 11-27-2006 12:00 AM

    Using Multiple Filegroups in a SQL Server Database

    This post is related to this tip: Using Multiple Filegroups in a SQL Server Database

    http://www.mssqltips.com/tip.asp?tip=967

  • 06-23-2008 1:02 PM In reply to

    Re: Using Multiple Filegroups in a SQL Server Database

    I had a database with 13 filegroups and a previous DBA had set two files up in each filegroup across two different drives. I used DBCC ShrinkFile(EMPTYFILE) to combine the 2 files in each file group and place on a large SAN drive. I also set the new data file to unlimited growth. When I ran the Shrinkfile, I received a Query Executed Successfully on large .ndf files in a matter of seconds, and when I ran the ALTER Database  Remove File, I received the error that the file could not be removed as it was not empty. Shortly thereafter I received an alert we have set up for databases notifying me that the filegroup was full. Would you please advise on what occurred here?

  • 06-23-2008 4:10 PM In reply to

    • aprato
    • Top 10 Contributor
    • Joined on 12-01-2007
    • Greater Boston
    • Posts 153

    Re: Using Multiple Filegroups in a SQL Server Database

    I've seen this in the past and I vaguely recall having to first move the tables and all indexes from the original filegroup to the destination filegroup by dropping and re-creating the indexes so they are re-created on the destination file group. 

  • 06-24-2008 11:21 AM In reply to

    Re: Using Multiple Filegroups in a SQL Server Database

    Thanks for the info.

Page 1 of 1 (4 items)