RESTORE FILELISTONLY
FROM DISK = 'M:\Backup_2005\Complete\YAFNET_backup_2013_11_21_192534_3162500.bak'
GO
LogicalNamePhysicalNameTypeFileGroupNameSize
YAFNETZ:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\YAFNET.mdfDPRIMARY4390912
YAFNET_logZ:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\YAFNET_log.LDFLNULL5308416
sysft_YafSearchZ:\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\YafSearchFPRIMARY468974
RESTORE FILELISTONLY
FROM DISK = 'M:\Backup_2005\Complete\YAFNET_backup_2013_11_21_192534_3162500.bak'
GO
RESTORE DATABASE YAFNET
FROM DISK =
WITH REPLACE,
RECOVERY,
MOVE '' TO 'M:\MSSQL\Data\',
MOVE '' TO 'M:\MSSQL\Log\'
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/