February 20, 2008 at 3:40 am
I never did anything with replication so bear with me..
I have two sql server 2000 servers and one of the databases is being replicated.
Both the publishing and subscribing databases are in Full Recovery Mode and the database is not that big.. about 4 GB
My problem is that the Brain Surgeon that set this up put the subscriber (destination) DB on the C:\ drive and the DB log on the subscribing Server grows and grows and fills up the drive. I shrink the log and logfile about once a week to manage it.. but is there anyway to fix it permanently? Eventually I will get a window to move the database to anyother server or to a different drive on the same server.. but it seems to me that I should be able to manage the log growth.. can I change the subscribing database from Full to Simple recovery mode without breaking replication?
February 20, 2008 at 4:56 am
As your database is in full recovery mode; your log file is getting biger and unable to free the space of logfile. For the solution of this questions you need to schedule tlog backup which will allow sql server to free up space and keep size of the log under control if still size is more you can increase the frequency of the tlog backup.
Also make sure that you do not have any opentransaction in your database for long time.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 20, 2008 at 5:05 am
Hi,
You can put the subscription database(s) into simple mode without issue.
Thanks,
Phillip Cox
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply