restore sql from bak file
RESTORE DATABASE MealManager FROM DISK='D:\data\SQL-Server\xx.bak' WITH MOVE 'Data_File' TO 'e:\xx_Data.mdf',MOVE 'Log_File' TO 'F:\xx_Log.ldf'
If you need a list of the logical and physical file names in the backup file:
RESTORE FILELISTONLY FROM DISK= 'D:\data\SQL-Server\xx.bak'
this should work.
RESTORE DATABASE MealManagerFROM DISK = 'D:\data\SQL-Server\xx.bak'


0 Comments:
Post a Comment
<< Home