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”
  }
}