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.
Friday, February 17, 2012
Error 21085: The retention period
Labels:
create,
database,
error,
followingerror,
manage,
messageerror,
microsoft,
mysql,
oracle,
period,
publication,
retention,
server,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment