Hi guys, i configured a transactional replication between two SQL server 2005. Whenever i performed a small test such as issueing updates to small amount of rows (eg 14000) on the publisher's db, these updates were propogated successfully.
However when i perform a larger test such as updating a 500,000 rows on a table on the publisher i get a log-reader error message in replication monitor.
the following message represents what is shown in replication monitor:
Error messages:
The process could not execute 'sp_MSadd_replcmds' on 'DEVSQL5\V2'. (Source: MSSQLServer, Error number: 1007)
Get help: http://help/1007
Could not allocate space for object 'dbo.MSrepl_commands'.'ucMSrepl_commands' in database 'distribution' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. (Source: MSSQLServer, Error number: 1007)
Get help: http://help/1007
IDistPut Interface has been shut down. (Source: MSSQL_REPL, Error number: MSSQL_REPL2000)
Get help: http://help/MSSQL_REPL2000
The last step did not log any message! (Source: MSSQL_REPL, Error number: MSSQL_REPL22037)
Get help: http://help/MSSQL_REPL22037
Any help would be greatly appreciated