Empty data files completely?

Hi,
Is there a way to completely empty some data files in the same filegroup so
I can delete them?
thanx
--
remove RmEaMkOnViEoTHvIoS from my email
svi komentari i razmisljanja su moja kao pojedinca i nikako se ne smiju
povezivati sa tvrtkom u kojoj radim
Yep. DBCC SHRINKFILE using the EMPTYFILE option. Then you can use ALTER DATABASE to drop the
file(s).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Zarko Jovanovic" <RmEaMkOnViEoTHvIoSmind_less@.bigfoot.com> wrote in message
news:1092738725.466707@.internet.fina.hr...
> Hi,
> Is there a way to completely empty some data files in the same filegroup so
> I can delete them?
> thanx
> --
> --
> remove RmEaMkOnViEoTHvIoS from my email
> svi komentari i razmisljanja su moja kao pojedinca i nikako se ne smiju
> povezivati sa tvrtkom u kojoj radim
>

Empty data files completely?

Hi,
Is there a way to completely empty some data files in the same filegroup so
I can delete them?
thanx
--
remove RmEaMkOnViEoTHvIoS from my email
svi komentari i razmisljanja su moja kao pojedinca i nikako se ne smiju
povezivati sa tvrtkom u kojoj radimYep. DBCC SHRINKFILE using the EMPTYFILE option. Then you can use ALTER DATA
BASE to drop the
file(s).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Zarko Jovanovic" <RmEaMkOnViEoTHvIoSmind_less@.bigfoot.com> wrote in message
news:1092738725.466707@.internet.fina.hr...
> Hi,
> Is there a way to completely empty some data files in the same filegroup s
o
> I can delete them?
> thanx
> --
> --
> remove RmEaMkOnViEoTHvIoS from my email
> svi komentari i razmisljanja su moja kao pojedinca i nikako se ne smiju
> povezivati sa tvrtkom u kojoj radim
>