My Photo
Name:
Location: United States

Saturday, May 19, 2007

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