Backup and Restore DB in multiple channels
Before taking the backup please check the database size CREATE TABLE #databases ( DATABASE_NAME VARCHAR ( 50 ), DATABASE_SIZE FLOAT , REMARKS VARCHAR ( 100 ) ) INSERT #Databases EXEC ( 'EXEC sp_databases' ); SELECT @@SERVERNAME AS SERVER_NAME , DATABASE_NAME , SYSMFM . source_file_name_main , SYSMFM . physical_name_main , SYSMFL . source_file_name_log , SYSMFL . physical_name_log , DATABASE_SIZE AS '(KB)' , ROUND ( DATABASE_SIZE / 1024 , 2 ) AS '(MB)' , ROUND (( DATABASE_SIZE / 1024 ) / 1024 , 2 ) AS '(GB)' , SYSDB . compatibility_level , SYSDB . create_date , ...