RESTORE FILE atau FILEGROUP

/*RESTORE FILE atau FILEGROUP

==================================================

 RESTORE DATABASE nama_database

 FILEGROUP = 'nama filegroup' atau

 FILE       = 'nama file'

 FROM DISK =  'lokasi file fisik'

 with REPLACE, RECOVERY

 */

 --Misal merestore database aku yang dibackup FILEGROUP--

 RESTORE DATABASE akku

 FILEGROUP = 'FGAkku'

 From Disk = 'D:\Sukriyadi\Backup\Backup_FGAkku.bak'

 WITH REPLACE, RECOVERY;

 --Misal RESTORE database "Akku" yg memilik file :

  -- akku_dat, akku_dat1, dan akku_dat2--

 

  RESTORE DATABASE akku

  FILE = 'akku_dat',

  FILE = 'akku_dat1',

  FILE = 'akku_dat2'

  FROM DISK = 'D:\Sukriyadi\Backup\Backup_Akku.bak'

  WITH REPLACE, RECOVERY;

 

SEMOGA BERMANFAAT

---