Friday, February 17, 2012

Error 21085: The retention period

When I try to create and manage publication in SQL 7.0, I got the following
error message:
Error 21085: The retention period must be less than the retention period for
the distribution database.
I try to create publishor and distributor on the same server.
Thank you.
can you do a sp_helpdistributor and sp_helppublication. Note the retention
period for your distributor. The retention period for your publication
should be less than or equal to the retention period of your distributor.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"royHe" <royHe@.discussions.microsoft.com> wrote in message
news:D19673BD-85CD-425A-A176-610D47E0ADE9@.microsoft.com...
> When I try to create and manage publication in SQL 7.0, I got the
following
> error message:
> Error 21085: The retention period must be less than the retention period
for
> the distribution database.
> I try to create publishor and distributor on the same server.
> Thank you.

No comments:

Post a Comment