USE [master]
GO

RESTORE DATABASE VDA FROM DISK = 'D:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLBackupVDA.bak'
WITH CHECKSUM,
MOVE 'VDA_Data1' TO 'D:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATAVDA.mdf',
MOVE 'VDA_Data2' TO 'D:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATAVDA_1.ndf',
MOVE 'VDA_Data3' TO 'D:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATAVDA_2.ndf',
MOVE 'VDA_Data4' TO 'D:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATAVDA_3.ndf',
MOVE 'VDA_Log1' TO 'D:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLLogVDA_4.ldf',
RECOVERY, REPLACE, STATS = 10;

10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.
100 percent processed.
Processed 54808 pages for database 'VDA', file 'VDA_Data1' on file 1.
Processed 61104 pages for database 'VDA', file 'VDA_Data2' on file 1.
Processed 61440 pages for database 'VDA', file 'VDA_Data3' on file 1.
Processed 63312 pages for database 'VDA', file 'VDA_Data4' on file 1.
Processed 2 pages for database 'VDA', file 'VDA_Log1' on file 1.
RESTORE DATABASE successfully processed 240666 pages in 441.744 seconds (4.256 MB/sec).