Hi All,
This is Naveen Maroju.
My previous DBA was created distribution database later on modified name as User database as Sales and it is placed in System folder because distribution . But now problem is I have recently migrated same database (from Old existing System folder Sales DB) to another server. Currently it is displaying in under user database folder in new server.
The issue is that when I am trying to configure Pull Transactional replication with remote publication in new server and it is throwing below error. I have dropped MS replication system tables in existing Sales database but no luck.
DB Size is 511 GB.
If anyone can advise on this that would be great helpful.
Error Name: The publication 'Sales-Pub' doesn't exists. Object 'Sales-PUB' doesn't exist or is not a valid object for this operation. Changed database context to 'Sales'(Microsoft SQL Error 20026)