restore database

Hi,
I'm still new with SQL Server 2000. We've just migrated to this platform for many reasons.
Now, I need to do replicate my installation on the server onto different PC, for testing purposes. I tried to do a restore of my backup (one specific db) onto my new SQL installation, but I'm getting error message pointing to location of my dat file, and so on. The installtion on my server is done on drive E:. My new install, on C:
Is there any parametres I could use to specify these, or am i missing something else.
Thanx in advance,
YvesYou can use WITH MOVE option in RESTORE DATABASE statement, to specify new
location for your db files. RESTORE DATABASE MyDB FROM MyDB_Device WITH
MOVE 'MyDB' TO 'e:\Program Files\Microsoft SQL Server\MSSQL\Data\MyDB.mdf',
MOVE 'MyNwindLog1' TO 'e:\Program Files\Microsoft SQL
Server\MSSQL\Data\MYDB.ldf'Look RESTORE DATABASE in BOL."Yves"
<ymanana@.hotmail.com> wrote in message
news:9E629EF8-E84E-4ECF-B64F-1770D9E94745@.microsoft.com...
> Hi,
> I'm still new with SQL Server 2000. We've just migrated to this platform
for many reasons.
> Now, I need to do replicate my installation on the server onto different
PC, for testing purposes. I tried to do a restore of my backup (one
specific db) onto my new SQL installation, but I'm getting error message
pointing to location of my dat file, and so on. The installtion on my server
is done on drive E:. My new install, on C:
> Is there any parametres I could use to specify these, or am i missing
something else.
> Thanx in advance,
> Yves|||You may also move the restore data and log files when using SQL Enterprise
Manager, Go to the second tab of the restore dialog box. There is a list of
current location and new location, simply type in the new location of the
files...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.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
"Yves" <ymanana@.hotmail.com> wrote in message
news:9E629EF8-E84E-4ECF-B64F-1770D9E94745@.microsoft.com...
> Hi,
> I'm still new with SQL Server 2000. We've just migrated to this platform
for many reasons.
> Now, I need to do replicate my installation on the server onto different
PC, for testing purposes. I tried to do a restore of my backup (one
specific db) onto my new SQL installation, but I'm getting error message
pointing to location of my dat file, and so on. The installtion on my server
is done on drive E:. My new install, on C:
> Is there any parametres I could use to specify these, or am i missing
something else.
> Thanx in advance,
> Yves