How can I remotely back up and import data from SQL Server into a local SQL Server?

server| Backup | data

One: Back up the remote database, copy the backup files to the local, and then restore the database locally.
Two: Copy the data files of the remote database with the log files to the local (the remote database service must be stopped before the copy can be copied), and then attach the database operation locally.
Three: (Need to know the remote database login name and password) Open Enterprise Manager, on the SQL Server group, select New SQL Server registration, click Next, enter the IP of the remote server in the available servers, and then click Add to continue to the next step, Follow the instructions step-by-step. Once the registration is complete, you can manipulate the remote database as you would a local database.

Backup DATABASE sys to disk= ' \ Your ip\ shared directory \a.bak ' with init

It is critical that the account that starts your remote SQL Server database service need to have permission to write on the local drive shared folder. Otherwise, it cannot be backed up.