SQL Server Replication Database task

Suppose you want to test the data in a production environment, such as modifying and testing stored procedures, changing and optimizing indexes, and so on. But if your users are connected to the database, you cannot disconnect the database. How do I get a copy of the database?

I. Using the Copy Database menu in a database task

The example is to copy the Northwind database from the default instance MSSQLSERVER to the named instance MySQLServer. Open the service as follows:

Figure A

Next, we'll fight. Copy database, task---database, Northwind

Figure II

Open the Database Replication Wizard, next, select the source server and target server, and require that the target server (MySQLServer) must be running SQL Server Agent, otherwise you will be prompted!

Here are two ways to replicate a database:

　　

Might

Then after the corresponding setup is complete, click Finish to the last step. An error occurs as follows:

　　

Figure Four

What's the reason? In fact, your target server (here is MySQLServer), the permissions of the proxy service is too low, this figure three has made a hint. Change the agent service permissions to start the account for the service LocalSystem (this process will automatically start the Integration Services service)

　　

Figure Five

Then click Finish to succeed.

　　

Figure Six

Reprint: https://www.cnblogs.com/Ryan_j/archive/2011/04/05/2005664.html

SQL Server Replication Database task