I don't think it will use the file once you use the EMPTYFILE argument...

You can use Alter Database Modify File and/or Modify Filegroup to rename files and filegroups.

To restore Database...

You could also create the number of files you want to end up with and use dbcc shrinkfile with the EMPTYFILE argument on the original file...once the data has been...

Speaking of IRS systems on SQL Server, I happen to be the DBA for an IRS system called HCTC (Health Care Tax Credit).

see:http://www.irs.gov/individuals/article/0,,id=109960,00.html

The system, built in 2003 with...

One characteristic of an exceptional DBA, in addition to the core knowledge, troubleshooting skills, research ability, etc, etc, is a set of almost infalible instincts. These instincts or "gut-feelings", which...