Backup/Restore

[golee]

hi to all,
Let me explain my doubt with an example.
Say, a database "xyz" and necessary database devices,backup("xyzBkUp") devices
are created. The "xyzBkUp.bak" is physically stored in say, "c:\MybackUp"
directory. All the required tables,views etc., are created and some data
in also inserted into the tables.
When i want to have the same database on some other system which is not at
all connected or linked with the system in which i created "xyz" database,
i will create a datbase say,"xyzNew", in that system and also the required
data devices(say, xyzNewBkUp.bak). When i try to restore the database by

#1. copying the xyzBkUp.bak file of "xyz" database in the same path
where i created the backup device(xyzNewBkUp.bak) for "xyzNew" database and

#2. by renaming the xyzBkUp.bak file of "xyz" database same as xyzNewBkUp.bak(which
was of "xyzNew" database) and then
#3. by "Restore" option given in SQL7.0 console window.

But the database is not getting restored where as the same works in SQL6.5.
Even in SQL7.0 also, it works if you create or place the xyzNewBkUp.bak file
of "xyzNew" database in the same path where you placed the xyzBkUp.bak file
of "xyz" database in the first system i.e., it keeps the path with it. but
it's not the good option. Suppose i created the backup device of "xyz" datbase
in the D: drive and the second system is not having D: drive at all, then
what will be the solution?
expecting immediate solution. help me out please.