use master
go
restore database new
from disk='D:\new.bak'
go

with replace 

use master
go
restore database new
from disk='D:\nsw.bak'
with replace
go

DECLARE @FILELISTONLY nvarchar(100),
	@QRESTORE nvarchar(300)
	



CREATE TABLE #tFILELISTONLY(
	LogicalName nvarchar(128), 
	PhysicalName nvarchar(260), 
	Type char(1), 
	FileGroupName nvarchar(128), 
	[Size] numeric(20,0), 
	[MaxSize] numeric(20,0)
)

SET @FILELISTONLY = N'RESTORE FILELISTONLY from DISK = N''D:\nsw.bak'''
INSERT #tFILELISTONLY EXEC(@FILELISTONLY)

select*from #tFILELISTONLY

LogicalName                                                                                                                      PhysicalName                                                                                                                                                                                                                                                     Type FileGroupName                                                                                                                    Size                                    MaxSize
-------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---- -------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- ---------------------------------------
ats342                                                                                                                           d:\datasql\MSSQL\data\ats342.mdf                                                                                                                                                                                                                                 D    PRIMARY                                                                                                                          180682752                               35184372080640
ats342_log                                                                                                                       d:\datasql\MSSQL\data\ats342_log.ldf                                                                                                                                                                                                                             L    NULL                                                                                                                             704905216                               35184372080640

(строк обработано: 2)

use master
go
RESTORE DATABASE [new] FROM DISK = N'D:\nsw.bak' WITH FILE = 1, 
MOVE N'ats342' TO N'd:\datasql\MSSQL\data\new.mdf', MOVE N'ats342_log ' 
TO N' d:\datasql\MSSQL\data\new_log.ldf', NOUNLOAD, REPLACE, STATS = 10
go



но получаю такую ошибку


Сообщение 5105, уровень 16, состояние 2, строка 1
Device activation error. The physical file name ' d:\datasql\MSSQL\data\new_log.ldf' may be incorrect.
Сообщение 3156, уровень 16, состояние 1, строка 1
File 'ats342_log' cannot be restored to ' d:\datasql\MSSQL\data\new_log.ldf'. Use WITH MOVE to identify a valid location for the file.
Сообщение 3013, уровень 16, состояние 1, строка 1
RESTORE DATABASE is terminating abnormally.