Copy database problem

Hi
I was wondering if anyone knows why this is happening.
* I detach or take a database offline
* Make a copy of that database files and copy to a different directory on
the same server
* Attach the original database
* Rename the copy and attach - when doing this it still points to the
original file location?If you are doing tthis using T-SQL, post it here.
When doing this, the device name will be the same, but not the file and path
of the 2 databases.
"Jaco" wrote:
> Hi
> I was wondering if anyone knows why this is happening.
> * I detach or take a database offline
> * Make a copy of that database files and copy to a different directory on
> the same server
> * Attach the original database
> * Rename the copy and attach - when doing this it still points to the
> original file location?|||Hi
I am doing this using EM not T-SQL.
Thanks
Jaco
"Mike Epprecht (SQL MVP)" wrote:
> If you are doing tthis using T-SQL, post it here.
> When doing this, the device name will be the same, but not the file and path
> of the 2 databases.
> "Jaco" wrote:
> > Hi
> >
> > I was wondering if anyone knows why this is happening.
> > * I detach or take a database offline
> > * Make a copy of that database files and copy to a different directory on
> > the same server
> > * Attach the original database
> > * Rename the copy and attach - when doing this it still points to the
> > original file location?