MOVE physical data file to another foler?

Is there any way that I can MOVE databases physical files
to different folder in same server? I had a restored many
databases from another server using BackupExec but it
created a folder MSSQL7 which is come from original path.
Now, my new server with SQL2000 located at MSSQL\DATA and
after restored using backupexec it put them at MSSQL7
\DATA, I have two Data folders which we don't like it.
I tried to use Copy DB wizard but it won't let me copy in
same SQL instence.
Please let me know you have any suggestion on this.
Thanks
SunnySunny,
INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224071
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"lintadsl" <lintadsl@.yahoo.com> wrote in message
news:05b901c35ac8$e6ffd1f0$a101280a@.phx.gbl...
> Is there any way that I can MOVE databases physical files
> to different folder in same server? I had a restored many
> databases from another server using BackupExec but it
> created a folder MSSQL7 which is come from original path.
> Now, my new server with SQL2000 located at MSSQL\DATA and
> after restored using backupexec it put them at MSSQL7
> \DATA, I have two Data folders which we don't like it.
> I tried to use Copy DB wizard but it won't let me copy in
> same SQL instence.
> Please let me know you have any suggestion on this.
> Thanks
> Sunny|||Thank you for the link.
I will take a little more time before post a question here.
That link was big help! Actually it tells me what I need.
Have a nice day.
Sunny
>--Original Message--
>Sunny,
>INF: Moving SQL Server Databases to a New Location with
Detach/Attach
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q224071
>--
>Dinesh.
>SQL Server FAQ at
>http://www.tkdinesh.com
>"lintadsl" <lintadsl@.yahoo.com> wrote in message
>news:05b901c35ac8$e6ffd1f0$a101280a@.phx.gbl...
>> Is there any way that I can MOVE databases physical
files
>> to different folder in same server? I had a restored
many
>> databases from another server using BackupExec but it
>> created a folder MSSQL7 which is come from original
path.
>> Now, my new server with SQL2000 located at MSSQL\DATA
and
>> after restored using backupexec it put them at MSSQL7
>> \DATA, I have two Data folders which we don't like it.
>> I tried to use Copy DB wizard but it won't let me copy
in
>> same SQL instence.
>> Please let me know you have any suggestion on this.
>> Thanks
>> Sunny
>
>.
>