Restoration of multiple Database

Here is a small example of such script. Execute the script below on your source server (with results to text option), it will just generate both backup and restore scripts. Modify the paths as needed. Then you can copy the backup part of the script and execute it on the source, mobe the back files to destination and execute the restore part at destination:

declare @back_path varchar(255);
declare @rest_path varchar(255);

select @back_path = 'C:\Dump\', @rest_path = 'D:\Dump\';

-- backup script, execute on the source server
select
	'backup database ' + [name] + '
	to disk=N''' + @back_path + [name] + '.bak'';
go

'
	from sys.databases
	where database_id > 4;

-- restore script, execute on destination server
select
	'restore database ' + [name] + '
	from disk=N''' + @rest_path + [name] + '.bak'';
go

'
	from sys.databases
	where database_id > 4;

set nocount off;
go

-- this spells out the script like this:
backup database SomeDB1
	to disk=N'C:\Dump\SomeDB1.bak';
go

-- etc
restore database SomeDB1
	from disk=N'D:\Dump\SomeDB1.bak';
go