rioooo

RESTORE DATABASE
    MyDB(nama DATABASE)
FROM DISK = '\\MyShare\MyBackup.bak'(lokasi file .bak)
WITH
    MOVE 'DataFile' TO 'D:\myNewDBLocation\DataFile.mdf'(naro DATA file nya dimana),
    MOVE 'LogFile' TO 'E:\\myNewDBLocation\LogFile.ldf' (naro log file nya dimana)
, REPLACE