consolidating two data files into one.

Using SS2000. We have a database that has two data files of the same name bu
t
in different folders. I want to move the database to a different drive. Is
there a way to combine the two data files into one?
Thanks,
--
Dan D.Kick people out of the database
do a dbcc shrinkfile emptyfile on the one going away ( that moves data into
the other file)
then alter database prod drop file file2
Backup everything first.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:6A3DC97A-CBA1-496D-A1D7-2E7CB0B39837@.microsoft.com...
> Using SS2000. We have a database that has two data files of the same name
but
> in different folders. I want to move the database to a different drive. Is
> there a way to combine the two data files into one?
> Thanks,
> --
> Dan D.|||Thanks Wayne.
"Wayne Snyder" wrote:

> Kick people out of the database
> do a dbcc shrinkfile emptyfile on the one going away ( that moves data int
o
> the other file)
> then alter database prod drop file file2
> Backup everything first.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:6A3DC97A-CBA1-496D-A1D7-2E7CB0B39837@.microsoft.com...
> but
>
>|||No problem... Have fun and good luck!
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:1BDAB943-A281-421C-8629-1933E12369E6@.microsoft.com...[vbcol=seagreen]
> Thanks Wayne.
> "Wayne Snyder" wrote:
>
into[vbcol=seagreen]
name[vbcol=seagreen]
drive. Is[vbcol=seagreen]