Error number: 1105 the primary group is full

Hi i am Oscar,
I have a problem with database Subscriber. I've created this database with
2 datafile (*.mdf). the first datafile has static size and second datafile
is define with unrestrictec file growth option . the replication have been
worked all time, until the disc has fulled. How is possible that database
Published has 1928 Mb size and Subscriber database grows up a lot of?
Have i configured something in Suscriber database?
Could you help me , please?
Best Regards
Message posted via http://www.sqlmonster.com
Very odd . On the subscriber are there any other tables which are not part
of the publication?
Also, please use sp_spaceused on the publisher and subscriber and post up
the results.
HTH,
Paul Ibison SQL Server MVP,
www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||well paul,
I have executed this storage procedure in Publisher and Suscriber y this
the results
Publishers.
BDIntranet8577.38 MB51.54 MB
1921176 KB973024 KB281384 KB666768 KB
Suscriber.
BDIntranet 55386.75 MB2567.94 MB
52550464 KB52194688 KB230888 KB124888 KB
There is datafile that it?s growing too much. i do not understand Why?
Best Regards,
oscar
Message posted via http://www.sqlmonster.com
|||I was expecting that most of the extra space would be unallocated, but that
is simply not the case. You have 44GB more space used on the subscriber.
Perhaps it is being used for other things apart from this subscription? Or
else you are not replicating deletes, and the subscriber holds all the
original data, much of which has been removed from the publisher?
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)