Hi,
when i try to run an push-replication on MS SQL 2000
i get the error "Log file is full" on the subscriber.
I tried to make this grow VERY much, but it doesnt help.
The table that fails has over 75000 posts, so maybe that is an issue.
The error occurs when i for the first time tries to sync it...
Any ideas?
// PeterTry breaking your task into smaller units of work.
You would normally be using "BeginTrans" and "CommitTrans" to free up the log space in a program after a unit of work has been completed.
Good Luck,|||Well, the thing is... i only want to replicate this to a server, and not
run any scripts. Shouldnt MS-SQL handle this?
I tried the push-operation without the LARGE-table (75000 posts)
and it worked. So it has something to do with that.
Any more suggestions?
Please?!!
// Peter
Originally posted by Bruce A. Baasch
Try breaking your task into smaller units of work.
You would normally be using "BeginTrans" and "CommitTrans" to free up the log space in a program after a unit of work has been completed.
Good Luck,sql
Thursday, March 22, 2012
Error on replication
Labels:
2000i,
database,
error,
file,
grow,
log,
microsoft,
mysql,
oracle,
push-replication,
replication,
run,
server,
sql,
subscriber
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment