How "SQL Server" deploys the local SQL Server servers to a remote server

Here the author uses SqlServer2012, native and remote Environment are Win7.

1. Select the database you want to deploy, and right-click the task to detach. Check Delete connection.

2. Now I can't see the data in the table on the left.

3. Find the location of the detached database locally, which is the location specified when the reader establishes the database. For example, the author's position is "D:\databaseContainer\moveCheck"

4. In this there are two database files, with _log.ldf as the log, which is generally not required. Make a copy of the required database to a remote server. For the convenience of file management, you can refer to other database files under that folder, it is placed under that folder, if there is a database with the same name, need to be replaced. In the case of paste replacement, it is important to delete the connection (the same step as the first step) in the SQL Server database, otherwise the error message "Replace the file in use failed" is reported.

5. Then right-click the database in SQL Server and select Attach. Specifies the location of the database, specifying that the details of the database will appear in the details after completion. If the log information for the data is present, select Delete it.

Then click OK, and after the database is refreshed, the database is deployed to the remote server.

How "SQL Server" deploys the local SQL Server servers to a remote server