Posted by Stu on 08/18/06 14:09

You want to use the WITH MOVE option; check the BOL. However, detach,
move, and attach should work fine.

HTH,
Stu

Mark D Powell wrote:
> Erland Sommarskog wrote:
> > Mark D Powell (Mark.Powell@eds.com) writes:
> > > In the event of serious problems I will drop the database, recreate it,
> > > restore using the backup over the new version, and fix the user access.
> >
> > You don't have to create the database prior to restoring it. RESTORE will
> > do that for you.
> >
> > --
> > Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
> >
> > Books Online for SQL Server 2005 at
> > http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> > Books Online for SQL Server 2000 at
> > http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
> I know a restore can recreate a database but since I want to change the
> location of the datafiles will it in this case allow me to change them
> on the screen where it shows the datafile names? I have changed them
> when I overlaid a production database with a test (upgrade) version
> that ran on the same server but I changed them to existing files for
> the existing producion database that I wanted to overlay.
>
> I should take a few minutes and try this on the test server.
>
> Thanks -- Mark --

[Back to original message]