Please Use this Script to Backup your db in 10 files BACKUP DATABASE [Databas_Name] TO DISK = 'C:\MSSQL_Backup\Database_FileName1.bak', DISK = 'C:\MSSQL_Backup\Database_FileName2.bak', DISK = 'C:\MSSQL_Backup\Database_FileName3.bak', DISK = 'C:\MSSQL_Backup\Database_FileName4.bak', DISK = 'C:\MSSQL_Backup\Database_FileName5.bak', DISK = 'C:\MSSQL_Backup\Database_FileName6.bak', DISK = 'C:\MSSQL_Backup\Database_FileName7.bak', DISK = 'C:\MSSQL_Backup\Database_FileName8.bak', DISK = 'C:\MSSQL_Backup\Database_FileName9.bak', DISK = 'C:\MSSQL_Backup\Database_FileName10.bak' WITH INIT , NOUNLOAD , NAME = 'Databas_Name backup', NOSKIP , STATS = 10 , NOFORMAT