Example of Taking Split Backups Database for SQL Server

1. Run this query
---------------------------------------------------
-----code:start-----
---------------------------------------------------

    BACKUP DATABASE DB_Simulasi TO
    Disk = 'C:\Backup\DB_Simulasi_1.bak',
    Disk = 'D:\Backup\DB_Simulasi_2.bak',
    Disk = '\\192.xxx.x.xxx\DbBackup\Backup\DB_Simulasi_3.bak';

---------------------------------------------------
-----code:end-----
---------------------------------------------------

Result Messages:
Processed 66832 pages for database 'DB_Simulasi', file 'SeaSQL_dat' on file 1.
Processed 1 pages for database 'DB_Simulasi', file 'SeaSQL_log' on file 1.
BACKUP DATABASE successfully processed 66833 pages in 19.560 seconds (26.693 MB/sec).


2. Check the availability of backup file

Source:
http://syntaxhelp.com/SQLServer/Backup/FULL