How to make two filegroups to one filegroup

Hello,
I have to filegroups like
database_data1 stored on d:
database_data2 stored on e:
How can I delete the database_data2 and tell SQL 2005 to copy all
data to database_data1?
Thanks for any help in advance!
A. KlemtOne way...
Assuming you have clustered indexes on all you tables is to drop and
recreate the index on the database_data1 filegroup this will also move
all the data over to database_data1
http://sqlservercode.blogspot.com/|||Hi
It is pretty much described in the BOL under "Moving database file"
"Andreas Klemt" <aklemt68@.hotmail.com> wrote in message
news:Oxkia5$JGHA.3200@.tk2msftngp13.phx.gbl...
> Hello,
> I have to filegroups like
> database_data1 stored on d:
> database_data2 stored on e:
> How can I delete the database_data2 and tell SQL 2005 to copy all
> data to database_data1?
> Thanks for any help in advance!
> A. Klemt
>

How to log select into/bulk copy transactions

Is there a way to be able to use select into and/or bulk copy statements AND have them logged into the transaction log? If I uncheck select into/bulk copy, these statements cannot be performed. If I leave them checked, the operations are not logged, making my transactions logs invalid.

EdBuilk copy operation are specially designed to be NONLOGGED. Since you have got operations that not looged in tranlog, there is no way to get db in consistant state using this tranlog. Thats why you need to perform full db backup.

In SQL2k u dont need perform full backup after builk ops anymore since they are logged thru BCM pages.

HTH,
OBRP