Restore with Transaction Log

ADS 8.0.0

Issue #1

DBA Tools -- Select Restore

Give a new database name

select Files and File Groups

Select Source -- ORIG_DB_WED.bak

SQL Generated is below which gives error

RESTORE DATABASE [loading] File=N'ORIG_DB_WED', File=N'ORIG_DB_WED_log' FROM DISK=N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\ORIG_DB_WED.bak' WITH FILE=1, MOVE N'ORIG_DB_WED_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\loading_1.ldf', MOVE N'ORIG_DB_WED' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\loading.mdf', NORECOVERY, NOUNLOAD, STATS=10
GO

attached pics for your reference 1, 2, 3, and 4

--------------------------------------

Issue #2

If you change the source to restore to Check Radio Button and select ORIG_DB_WED

You get incorrect Syntax -- which is 2nd issue --look picture error.png attached

RESTORE DATABASE [loading] File=N'ORIG_DB_WED' FROM DISK=N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\ORIG_DB_WED.bak' WITH FILE=1, MOVE N'ORIG_DB_WED_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\loading_1.ldf', MOVE N'ORIG_DB_WED' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\loading.mdf', NORECOVERY, NOUNLOAD, STATS=10
GO
RESTORE LOG FROM DISK=N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\ORIG_DB_WED.bak' WITH FILE=2, NORECOVERY, NOUNLOAD, STATS=10
GO