Monday, July 13, 2015

Use WITH MOVE to identify a valid location for the file.

USE [master]
GO
RESTORE DATABASE [DBName] 
FROM  DISK = N'Path to BAK File' 
WITH  FILE = 1,  
MOVE N'Logical File Name' TO N'New Path to mdf file',  
MOVE N'Logical File Log Name' TO N'New Path to log file',  
NOUNLOAD,  REPLACE,  STATS = 1
GO


To get logical file list

RESTORE FILELISTONLY 
FROM  DISK = N'path to bak file' 
WITH  FILE = 1 
GO

No comments:

Post a Comment