COMANDO    

dopo lunghi test e link visitati ecco il comando funzionante riassemblato; Paremetri: backup name, Logical Name, File Name

RESTORE DATABASE "DBNAME"    
FROM DISK= N'\\192.168.0.1\Backup\sql\Backupdb.bak'    
WITH FILE= 1,    
MOVE N'DB_Data' TO N'H:\DB_Data.mdf',    
MOVE N'DB_1_Data' TO N'H:\DB_data_1.ndf',   

MOVE N'DB_Log' TO N'H:\DB_Log.ldf',      // mettere tutti i datafile per logical file

MOVE N'DB_Log' TO N'H:\DB_Log.ldf',    
NOUNLOAD, STATS=10