elstar.com.au

Web Site explains restoring a database from another sql server

http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1102260,00.html

RESTORE FILELISTONLY

This is another command that can be run on the backup files.

RESTORE FILELISTONLY FROM DISK = 'C:\SQL\Backup\North.bak'

RESTORE DATABASE NORTH
FROM DISK = 'C:\SQL\Backup\North.bak'
WITH MOVE 'NORTH_Data' TO 'D:\SQL\Data\North_Data.mdf',
MOVE 'NORTH_Log' TO 'E:\SQL\Log\North_Log.ldf'