RESTORE FROM BAK WITH QUERY SQL SERVER

USE [master]
 RESTORE DATABASE [MYDATA] 
 FROM  DISK = N'l.bak' 
 WITH  FILE = 1,  
 MOVE N'LEVENT_Data' TO N'F:\LOGO\DB\LEVENT\LEVENT_Data.mdf',  
 MOVE N'LEVENT_Log' TO N'F:\LOGO\DB\LEVENT\LEVENT_Log.ldf',   
 NOUNLOAD,  REPLACE,  STATS = 1
 GO



 RESTORE FILELISTONLY FROM DISK = 'serkan.BAK' WITH FILE = 1

Leave a comment