Copy whole database from SQL Server to SQL Server using linked server
Backup/restore, the Copy Database Wizard, and Log Shipping are all potentially better choices than linked server copies.

See the following documentation:


Back Up and Restore of SQL Server Databases
Use the Copy Database Wizard
About Log Shipping (SQL Server)