Lafa,

Cant you use Enterprise manager(EM) ,Query yzer(QA) etc? If through QA,
you can do:

RESTORE DATABASE NewNorthwind
FROM DISK='C:\SQL2000\BACKUP\nwindbackup.BAK'
WITH REPLACE, MOVE 'Northwind' TO 'C:\SQL2000\Data\Newnorthwnd.mdf',
MOVE 'Northwind_log' TO 'E:\SQL2000\log\Newnorthwnd.ldf'

Thru EM, right click on 'databases' node |All tasks | restore database |
feed in the new database name and point to the .BAK location.


--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com

"lafa" <lt> wrote in message
news:u$phx.gbl... 
and