USE [master]
RESTORE DATABASE [prova]
FROM  DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup\prova_copia.bak'
WITH  FILE = 1,  NORECOVERY,  NOUNLOAD,  STATS = 5

RESTORE DATABASE [prova]
 FROM  DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup\prova_copia.bak'
 WITH  FILE = 2,  NOUNLOAD,  STATS = 5

GO