偶现在的问题就是,当2台WIN2000的机器复制的时候,由于权限的问题,总是无法成功,有人搞定了吗?请指教。
解决方案 »
- primary key 与 foreign key 的问题
- 建立1000列的表,疑问
- win2003,sql server2000的服务管理器设为自动启动,为什么有时候系统启动后自动启动不了
- sqlserver2000BCP命令遇到的问题
- 如果存储过程的结果是一个表,那么我怎样才能将两个存储过程的结果表做inner join联接呢?谢谢
- 大型数据库的备份问题
- ]# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket
- 想一个表1-10赋随机值sql语句怎么写?
- 列举sql的触女器可以触发什么动作,能否回滚引起触发的事务
- 急问:误删除了一个表,如何恢复,如果是用日志,请告诉我具体步骤,谢谢!!
- 自定义函数:拼接字符串(有点难度)
- 安装数据库时遇到的奇怪问题(100分)
2000下的複製沒有弄過,好像應該更複雜吧?我剛試了一下用一台Server上的第二個實例去做,沒有成功。
对于由于权限问题无法进行的复制,可以把sql安全验证设置为与操作系统混合验证方式,然后agent中的帐号设置为能够访问目标机器的系统帐号,就不会出现权限问题了:)
我一般在目标机器上建立要复制的数据库名,然后把两台机器的sql server 服务停掉,copy data目录下的两个文件过来,覆盖目标机器上建立的空数据库文件就ok了!! 屡试不爽啊!
CREATE TABLE [dbo].[user_Info1] (
[user_ID] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[user_PWD] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[user_Des] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
此语句在SQL7中能正确运行吗?它是什么意思呢?
In this mode of replication, one site is considered the owner, or publisher, of a published article (a table or a subset of a table), and other sites subscribe to that article. All changes made to the article must be made at the publisher and then replicated to the subscribers. 2.Merge replication
Although the publisher defines the articles to be published, any participating sites can make changes. System tables keep track of the changes, which are then propagated to all participants, including the original publisher. You can define which type of conflict resolution to use in the event of conflicting updates made by multiple sites. 3.Snapshot replication
All data from the publishing site is periodically copied to all the subscribing sites. Individual changes aren't propagated. This method was formerly called scheduled table refresh.
如何保证远程两台SQL的数据一致,同步更新?
All data from the publishing site is periodically copied to all the subscribing sites. Individual changes aren't propagated. This method was formerly called scheduled table refresh.2.Transactional replication and (with updated subscriber)
In this mode of replication, one site is considered the owner, or publisher, of a published article (a table or a subset of a table), and other sites subscribe to that article. All changes made to the article must be made at the publisher and then replicated to the subscribers. 3.Merge replication
Although the publisher defines the articles to be published, any participating sites can make changes. System tables keep track of the changes, which are then propagated to all participants, including the original publisher. You can define which type of conflict resolution to use in the event of conflicting updates made by multiple sites.
如何实现两台的数据同步更新:通过INTERNET连接???
指教!!!!!!!!!!1
说一说做法,注意事项,也好让大家学习!