Administration > SQL Server Administration > Administration Tasks > Database Administration > Copying a Database
  
Copying a Database
You can copy a database by using backup and restore in one of the following tools:
Model Explorer
ScfUtils command line interface
Model Manager
SQL Server Management Studio
To copy a database, do the following:
1. Backup the database on your current server.
2. Copy the .bak backup file to
3. Restore the database on the new server.
For more information, refer to the following SQL Server help topics:
Copy Databases to Other Servers
https://docs.microsoft.com/sql/relational-databases/databases/copy-databases-to-other-servers?view=sql-server-2017