USE master
GO
-- First determine the number and names of the files in the backup.
RESTORE FILELISTONLY
FROM disk = 'C:\yourfolder\yourdbbackupfile.BAK'
RESTORE DATABASE yourdatabasename
FROM disk = 'C:\yourfolder\yourdbbackupfile.BAK'
WITH NORECOVERY,
-- change location
MOVE 'xxx_Data' TO 'C:\newfolder\newfile.MDF',
MOVE 'xxx_Log' TO 'C:\newfolder\newfile.LDF'
GO
RESTORE LOG yourdatabasename
FROM disk = 'C:\yourfolder\logfile1.TRN'
FROM disk = 'C:\yourfolder\logfile2.TRN'
WITH NORECOVERY
GO
-- WITH NORECOVERY need attach database, or WITH RECOVERY then dont need attach.
