Catalog = MyCatalog 
Password = "IYN0eZTw2BrRcA/MNGCwGHb9OrHDRykMMF8jSxtA7zUF" #安装客户端密码 
#要一样 
File Retention = 2 weeks 
Job Retention = 2 weeks 
AutoPrune = yes 
} 

#List of files with 192.168.22.30 
FileSet { 
  Name = "fileset-22.30" 
  Include { 
    Options { 
      signature = MD5 
      compression = GZIP 
      IgnoreCase = yes 
    } 
  File = "d:/test" 
  } 
} 


#Define backup of 192.168.22.30 
Job{ 
  Name = "bak-192.168.22.30" #安装客户端名字要一样 
  Type = Backup 
  Client = bak-192.168.22.30 
  FileSet = "fileset-22.30" 
  Schedule = "task-22.05" # 调用/etc/bacula/conf/ myj-sechedules.conf的配置周一到 
#六增量备份，周日全量备份 
  Storage = PrimaryFileStorage,SecondaryFileStorage,TertiaryFileStorage,QuaternaryFileStorage 
  Messages = Standard 
  Pool = Default 
  Full Backup Pool = full-pool 
  Incremental Backup Pool = inc-pool 
  Prefer Mounted Volumes = no 
  Priority = 10 
  Write Bootstrap = "/var/spool/bacula/%c.bsr" 
}

del “C:\DatabaseBackups\DB1.bak”
del “C:\DatabaseBackups\DB2.bak”
del “C:\DatabaseBackups\DB3.bak”
sqlcmd -S .\DATABASE1 -Q “BACKUP DATABASE DB1 TO DISK = ‘C:\DatabaseBackups\DB1.bak’ WITH INIT, NAME = N’Automatic back up of database’, STATS = 1”
sqlcmd -S .\DATABASE1 -Q “BACKUP DATABASE DB2 TO DISK = ‘C:\DatabaseBackups\DB2.bak’ WITH INIT, NAME = N’Automatic back up of database’, STATS = 1” 
sqlcmd -S .\DATABASE1 -Q “BACKUP DATABASE DB3 TO DISK = ‘C:\DatabaseBackups\DB3.bak’ WITH INIT, NAME = N’Automatic back up of database’, STATS = 1” 
exit

Job {
  Name = My-Databases
  Type = Backup
  Level = Incremental
  Client = database-fd
  FileSet = database-FS
  Schedule = WeeklyCycle
  Storage = BackupSD
  Pool = BackupPool
  Messages = Standard
  Client Run Before Job = C:\DatabaseBackups\script\sql.bat
  Write Bootstrap = “/BackupNAS/BaculaBootstraps/%c_%n.bsr”
}

FileSet {
…. 

  Include {
    …. 

    # Backup database target directory
    File = “C:/bacula-mssql”
  }
}
…. 

Job {
  Name = “example.net”
  Type = Backup
  …. 

  # Starting the upload of the binary SQL backup copy:
  RunScript {
    RunsWhen = Before
    FailJobOnError = No 

    # Cleaning up and/or creating a place to save the “dump”
    Command = “if exist c:\\bacula-mssql rmdir /s /q c:\\bacula-mssql”
    Command = “mkdir c:\\bacula-mssql” 

    # Starting up the upload for a database backup
    # (you’ll have to input your database’s name instead of “dbname” in the next line)
    Command = “SET dbname=example_DB & sqlcmd -Q \”SET LANGUAGE us_english; BACKUP DATABASE $(dbname) TO DISK=’C:\\bacula-mssql\\$(dbname).bak’\””
  }
  #
  RunScript {
    RunsWhen = After
    RunsOnFailure = yes 

    # Offloading resources after everything is complete
    Command = “if exist c:\\bacula-mssql rmdir /s /q c:\\bacula-mssql”
  }
}