Perform bulk backup operation using SSIS
Follow the following steps in SSIS for the bulk backup operation.
1. Add a For each loop container on the SSIS Package
2. Add Database backup component to the Loop container
3. Configure the For Each loop for objects in SQL Database ( This will loop through all the database in the particular server)
4. Pass the Database Name to the “Database Backup component” using Expression
5. Provide the backup location — You can concatenate DateandTime with the backup file name to avoid overwriting.