Removing a File From a Filegroup

Sooner or later you'll need to remove a file from a filegroup. Easy enough to click 'remove', but what happens if that file has data in it? We'll show you the trick you need to get it done!

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

varun singh on 12/7/2009

Author could have also included a script to show how to move the data between files (in the same filegroup) before emptying things.

John on 12/7/2009

It was not clear if the database can be live while emptying and deleting files.

Yuga on 12/7/2009

good video; probably can be more concise

Steve Harris on 12/9/2009

maybe talk about how you could specify where the data would go if you did want to direct it to a specific location

Sam Schafer on 12/9/2009

Thank you, Andy. Answered a question I've had for a long time about the file's status after it is empty. Well done!

Raju on 12/14/2009

Good Stuff

yeskay on 2/4/2010

That was really helpful...thanks.

ipsita on 2/7/2010

very good

A Alagu Ganesh on 2/10/2010

Good