I can not delete subscriptions
-
i create a merged replication,but the capacity of the log files to be too large.
the capacity of my database is 2GB.
after replicate it was 3GB.
my replication process terminated abnormaly and replicate stoped.
thererof I can not disable replication service.
please guide meeeeeeeee
-
This was removed by the editor as SPAM
-
When you say replication stopped, which agent failed/stopped?
-
thanks o lot for your reply but my difficult did not solved.
I uninstall my sqlserver and again install it and restore my database,but
my database is in replication status and i cannot design my database.
i can not rename or delete tables field.
my agent is working correctly.
please guide meeeeeee
-
There are couple of things you could try
1. try to disable the replication (menu on right clicking the replication node)
2. if the above fails,Try to create new replication on the same DB and disable it. This is just to create all replication related system entries.
3. Or the third way is a cheat, but sure does work.
- Right clicking on the DB root node and selecting the properties, there is property where you can set 'allow system table updates'.
- Go to sysdatabases and change the replication column to '0' from '1' for the Db in question. This column is the one which says a DB is replicated. Once it is changed to '0', the DB is no longer replicated as far as the Server is concerned.
- create the replication again on top the DB and remove it systematically to get the server cleaned (all the manual crook methods will leave system setup hanging with unwanted half-settings which has to be cleaned.
Try these and let us know.
Regards
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply