Take backup with password and multiple file for faster speed

                       Backup:

                  BACKUP DATABASE [Leave_Management] TO
'                  DISK = 'E:\Leave_Management_file1.bak',
                      DISK = 'F:\Leave_Management_file2.bak'
                     WITH MEDIAPASSWORD='Securepassword'

                      filelist for verification:-

          RESTORE FILELISTONLY FROM DISK = 'E:\Leave_Management_file1.bak',
          DISK = 'F:\Leave_Management_file2.bak'
          WITH MEDIAPASSWORD='Securepassword'

                      
           Restoration for multiple files with password:

          RESTORE database [Leave_Management] FROM DISK = 'E:\Leave_Management_file1.bak',
           DISK = 'F:\Leave_Management_file2.bak'
           WITH MEDIAPASSWORD='Securepassword',
            MOVE 'Leave_Management' TO 'C:\Program Files\Microsoft SQL                  Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Leave_Management.mdf',
           MOVE 'Leave_Management_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Leave_Management_log.ldf'