使用SQL SERVER将数据库从一台计算机复制到同一网络中的另一台计算机 [英] Copy database from a computer to another in the same network using SQL SERVER

问题描述

我在同一网络的两台计算机COM1和COM2上安装了180天的SQL SERVER 2008 RC0企业版评估

我尝试使用Push订阅进行事务复制

我通过COM1配置分发服务器和发布服务器，并在其上配置PUSH订阅服务器以将COM2用作订阅服务器

复制配置正确，但启动时出现错误

该进程无法连接到订阅服务器"COM2 \ SQLEXPRESS"

注意:我使用实例SQLEXPRESS安装了sql，由我决定

问题:对于COM2，是否必须启动sql Server代理，因为它是从发布者COM1启动的推送订阅者?

I have SQL SERVER 2008 RC0 Enterprise Edition Evaluation 180 days installed on 2 computers COM1 and COM2 on the same Network

i tried to make transaction replication using Push subscription

i configure the Distributor and the publisher over COM1 and configure the PUSH subscriber on it to use COM2 as subscriber

the replication configured right but when it start there is an error

The process could not connect to subscriber ''COM2\SQLEXPRESS''

Note: i installed the sql using instance SQLEXPRESS it is up to me

QUESTION: for COM2 The sql server agent is must to be start or not as it is push subscriber that initiate from the publisher COM1 ? and only COM1 Sql agent must be start?

推荐答案

SQL复制是开始工作的真正痛苦，有很多很多事情可能会出错...

看看

SQL replication is a real pain to get working, there are many, many things that can go wrong ...

Have a look though the following[^]

It''s much easier to have a domain login (with non-expiring password) that the two servers use for logins and sharing REPL data with

这篇关于使用SQL SERVER将数据库从一台计算机复制到同一网络中的另一台计算机的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！