LOG file corrupted

[ritesh.gupta]

We have one database of 5 GB of which when we take the backup and restore in another location, it says "Device Activation Error. The Physical file name e:\database\nike_log.ldf may be incorrect".
The database has more than one log file.
Now when we use another procedure to create new database and stop the sql, then replace the old mdf file and REBUILDLOG. (Ie dbcc rebuildlog(nike,1,0)). It says incorrect DBCC Statment.

Pl. suggest us what to do?

[rmiao]

First of all, there is no reason to use more than 1 log file IMO. In this case, does target server have e:\ drive at all? Does e:\database exist?

[ritesh.gupta]

The Target server have the E: drive but i am restoring the DB at d: drive. The source server from where i picked the backup of DB has the e:\database and the same db has 2 different log files.

[rmiao]

Then you have to create 2 log files for target db, and restore with move option if db files are in different location.