I am testing some restores for disaster recovery purposes. We dump our database
on a nightly basis to a .dat file on another server. During the day, we
dump our transaction log file to a file on another server as well (hourly).
This is a different .dat file than the database .dat file. Each hourly
transaction log dump is a different file in the log.dat file but we do not
specify a filegroup. In trying to do a restore for disaster recovery, I
am trying the following:

RESTORE DATABASE OnyxImport
FROM DISK =
'\\OnyxRptServer\OnyxServer_Info\backups\onyxdump_50.DAT'
WITH norecovery
MOVE 'onyxdata' TO 'e:\mssql7\data\OnyxImport_Data.MDF',
MOVE 'onyxlog' TO 'e:\mssql7\data\OnyxImport_Log.ldf'

restore log onyxImport
from disk = '\\onyxrptserver\onyxserver_info\onyxLOGrestore1.dat'
with recovery

The file onyxLOGrestore1.dat is a file that has one file per every hour of
transactions throughout the day.

The problem is that if I do the above, the database restores fine but the
transaction log from the second step restores with 0 pages written. If I
run the second step (the step for the transaction log file) and specify each
file within it as a separate step it seems to work fine. For example:
RESTORE DATABASE OnyxImport
FROM DISK =
'\\OnyxRptServer\OnyxServer_Info\backups\onyxdump_50.DAT'
WITH norecovery
MOVE 'onyxdata' TO 'e:\mssql7\data\OnyxImport_Data.MDF',
MOVE 'onyxlog' TO 'e:\mssql7\data\OnyxImport_Log.ldf'

restore log onyxImport
from disk = '\\onyxrptserver\onyxserver_info\onyxLOGrestore1.dat'
with file =2,
norecovery

restore log onyxImport
from disk = '\\onyxrptserver\onyxserver_info\onyxLOGrestore1.dat'
with file =3,
recovery

I thought I should be able to restore all files by specifying the 1 .dat
file. Any feedback on this? Thanks. Sorry if my wording is confusing!