Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

trans replication-snapshot creates a huge log file

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I have been able to replicate several databases
successfully, however one of the databases is ~27 GB and
the snapshot creates a huge log file around 10+ GB.

I tried several things such as specifying the subscriber
db as simple, backing up/truncating the log file when left
as full. And nothing seems to work. The log file becomes
too large. If my snapshot is smaller the log file still
balloons but doesn't eat all the drive space and
eventually comes back down to around 1 GB after the
snapshot.

Any remedy for this, without buying additional drives. I
would like to push one complete snapshot if possible.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top