SQL Server Replication Database task

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.