• sounds like you need to create a new filegroup with its file on the new drive and then move your tables to it by recreating\creating its clustered index.

    see -http://www.mssqltips.com/sqlservertip/2442/move-data-between-sql-server-database-filegroups/

    ---------------------------------------------------------------------