Hi Venki,

You just have to do a RESTORE of the backup on the other server. Let's say the name of your backup file is "myBackup.bak" and you copy it to the root of c:.

First off, you need to find the logical names of the files:

RESTORE FILELISTONLY FROM DISK = 'c:\myDB.bak'

Make a not of the LogicalName for both datafile and logfile (let's say it's myDB_Data and myDB_log).

Next you RESTORE the database with the WITH MOVE clause so you can specify where on the second server you want to put the database.

RESTORE DATABASE myDB

FROM DISK = 'C:\myDB.bak'

WITH MOVE 'myDB_Data' TO 'C:\DATA\myDB.mdf',

MOVE 'myDB_Log' TO 'C:\DATA\myDB_log.mdf'

GO

HTH!

/Elisabeth