Copy whole database from SQL Server to SQL Server using linked server I am using SQL Server 2014 Management Studio installed in my system. And using linked server I have connected to a linked server. 

Now here I need to copy whole database from linked server to my local SQL Server using linked server itself.

I am using a linked server instead of backup/restore because using linked server I can copy remote database.

Tool used: Microsoft SQL Server 2014 Management Studio.
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)