第二创建出版物 第一步没问题之后可以顺利完成第二步(创建发布)
--
完成之前得到这样的信息
Create a transactional publication from database 'Northwind'.
The following types of Subscribers may subscribe to this publication:
Servers running SQL Server 2000
Publish the following tables as articles:
'Categories' as 'Categories'
'CustomerCustomerDemo' as 'CustomerCustomerDemo'
'CustomerDemographics' as 'CustomerDemographics'
'Customers' as 'Customers'
'Employees' as 'Employees'
'EmployeeTerritories' as 'EmployeeTerritories'
'Order Details' as 'Order Details'
'Orders' as 'Orders'
'Products' as 'Products'
'Region' as 'Region'
'Shippers' as 'Shippers'
'Suppliers' as 'Suppliers'
'Territories' as 'Territories'
The name of this publication is 'Northwind'. The description is 'Transactional publication of Northwind database from Publisher XXX\EDWARDS.'.
Do not filter data in this publication.
Do not allow anonymous subscriptions to this publication.
Run the Snapshot Agent at the following scheduled times:
Occurs every 1 day(s), at 11:02:00 PM., ending 8/30/2004
Run the Snapshot Agent as scheduled.
1.不是报错信息 遇到该提示,可以在D盘建立一文件夹(ReplData),设置该文件夹访问权限,设好之后回到SQL中继续下一窗口
---会弹出如下信息
Configure 'XXX\EDWARDS' as a Publisher. Use 'XXX\EDWARDS' as the Distributor.
The SQL Server Agent service on 'XXX\EDWARDS' must be started manually.
Use '\\XXX\D$\ReplData' as the root snapshot folder for Publishers using this Distributor.
Store the distribution database 'distribution' in 'C:\Program Files\Microsoft SQL Server\MSSQL$EDWARDS\Data'.
Store the distribution database log file in 'C:\Program Files\Microsoft SQL Server\MSSQL$EDWARDS\Data'.