Full copy SQL server database from source to destination

1. Copy  databases from source

----------------------------

USE master;

GO 

ALTER DATABASE [DatabaseName]

SET RECOVERY FULL; 

BACKUP DATABASE [DatabaseName]

    TO DISK = 'Backup Location\xyz.bak'  

    WITH FORMAT 

GO  

Copy the back-up file to your destination folder

2. Restore databases at destination

---------------------------------

RESTORE DATABASE [DatabaseName] 

   FROM DISK = 'Backup Location\xyz.bak'  

    WITH RECOVERY,

      MOVE 'xyz' TO  

         'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Data\xyz.mdf',  

      MOVE 'xyz_log' TO 

         'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Data\xyz_log.ldf'; 

GO

Restore backed up database with different name at destination
RESTORE DATABASE [DPE-OPL] FROM DISK='D:\DB-Backup\4th Sept 2018\SQL\DPE-OPL-INT.bak'
WITH
MOVE 'DPE-OPL-INT' TO 'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Data\DATA\DPE-OPL.mdf',
MOVE 'DPE-OPL-INT_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Data\DPE-OPL_log.ldf'

3. Rename the DB in Management Studio