Tuesday, March 27, 2012

Basic problems with replication

Hi
I've just installed Sql Server 7 and wanted to see how replication works.
With DTS i copied Northwind database so now i have two db Northwind and
Northwind_copy on my server.
Using wizards (default values) I've tried snapshot replication from
Northwind (publication) to Northwind_copy (pull subscription, I used sa
login without password ? is it correct ? ).
It seems easy but doesn't work ;(
Snapshot agent session details:
7) The process could not bulk copy out of table
'[dbo].[syncobj_0x3044324641344544]'
6) Bulk copied snapshot data for article 'Categories' (0 rows)
5) Bulk copying snapshot data for article 'Categories'
4) Locking published tables while generating the snapshot
3) Generating Schema script for article 'Categories'
2) Connecting to Publisher 'MyServer'
1) Initializing
In Pull Substraction window:
Could not get license information correctly. The step failed
Thanks
urga
Hi,
For Snapshot replication , no need to copy the objects to Northwind_copy
database. Automatically snapshot replication will copy the selected
articles to destination database.
Licensing:-
- check the licensing in control panel and see how many license you have for
sql 7
- check this registry key as well for previlages..
hklm\system\currentcontrolset\services\licenseinfo \mssql7.0
-- Apply SP4 for SQL 7 snd check.
Thanks
Hari
MCDBA
"urga" <urga@.go2.pl> wrote in message
news:cbtu2h$r0f$1@.nemesis.news.tpi.pl...
> Hi
> I've just installed Sql Server 7 and wanted to see how replication works.
> With DTS i copied Northwind database so now i have two db Northwind and
> Northwind_copy on my server.
> Using wizards (default values) I've tried snapshot replication from
> Northwind (publication) to Northwind_copy (pull subscription, I used sa
> login without password ? is it correct ? ).
> It seems easy but doesn't work ;(
> Snapshot agent session details:
> 7) The process could not bulk copy out of table
> '[dbo].[syncobj_0x3044324641344544]'
> 6) Bulk copied snapshot data for article 'Categories' (0 rows)
> 5) Bulk copying snapshot data for article 'Categories'
> 4) Locking published tables while generating the snapshot
> 3) Generating Schema script for article 'Categories'
> 2) Connecting to Publisher 'MyServer'
> 1) Initializing
> In Pull Substraction window:
> Could not get license information correctly. The step failed
> Thanks
> urga
>
>
sql

No comments:

Post a Comment