Back Up Database 02 (File or Filegroup)

 ---DATABASE---

Create database akku

on primary

( name = akku_dat,

  filename = 'd:\sukriyadi\akku_dat.mdf',

  size = 10,

  maxsize = 50,

  filegrowth = 15%),

  filegroup FGAkku

( name = akku_dat1,

  filename = 'd:\sukriyadi\akku_dat1.ndf',

  size = 10,

  maxsize = 50,

  filegrowth = 5),

( name = akku_dat2,

  filename = 'd:\sukriyadi\akku_dat2.ndf',

  size = 10,

  maxsize = 50,

  filegrowth = 5)

  log on

( name = akku_log,

  filename = 'd:\sukriyadi\akku_log.ldf',

  size = 5mb,

  maxsize = 25mb,

  filegrowth = 5mb)

 

  ---BACK UP FILE atau FILEGROUP---

  /*Perintah :

  BACKUP DATABASE nama_database

  <file_or_filegroup> [,...n]

  TO lokasi backup

  */

  --Misal backup database "Akku" yang memiliki filegroup FGAkku

  BACKUP DATABASE akku

  filegroup = 'FGAkku'

  TO DISK = 'D:\Sukriyadi\Backup\Backup_FGAkku.bak'

 

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

  -- akku_dat, akku_dat1, dan akku_dat2--

 

  BACKUP DATABASE akku

  FILE = 'akku_dat',

  FILE = 'akku_dat1',

  FILE = 'akku_dat2'

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

  /* Mirrored Backup

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

  Backup kedalam dua lokasi secara bersamaan

  Backup Database nama_database

  To Disk= 'Lokasi Backup'

  Mirror to Disk= 'Lokasi Backup2'

  With Format

  */

 

  --Misal backup database 'akku'

  Backup Database akku

  to disk = 'D:\Sukriyadi\Backup\akkuFULL.bak'

  Mirror to disk = 'D:\Sukriyadi\Backup-2\akkuFULL2.bak'

  with Format

  /*Backup Compression

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

  Backup Database nama_database

  to disk= 'Lokasi Backup'

  with Compression

  */

 

  --misal backup database 'akku'

 

  Backup Database akku

  to disk = 'D:Sukriyadi\Backup-2\akkuFULLcomp.bak'

  with Compression

SEMOGA BERMANFAAT

---