January 7, 2008 at 5:34 pm
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
February 27, 2008 at 7:47 am
Check and make sure you have enough disk space for the files to grow. If the DB files are set to autogrow, they will grow until they run out of disk space or reach your defined limits.
Also, if you are using SQL2k5 Express, no matter how big your disks are, you are limited to a 3gig maximum. This error will show up in the SQL logs.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply