Implementing Native MSSQL Transactional Replication
mlzsmg
Posts: 2
Hi All,
After configuring a database for replication I am finding that my 15minute SQB backup files grow from 5MB to 590MB. This is obviously eating a lot more disk space and I am at a loss as to what to do in order to bring the SQB files back to the normal size.
So far I have torn down and re-implemented the Transactional replication via pure sql and using the management interface but each time the result is the same. Also I have shrunk the database log files and turned off Schema replication (read that this can cause an issue).
Any help much appreciated.
Sean
After configuring a database for replication I am finding that my 15minute SQB backup files grow from 5MB to 590MB. This is obviously eating a lot more disk space and I am at a loss as to what to do in order to bring the SQB files back to the normal size.
So far I have torn down and re-implemented the Transactional replication via pure sql and using the management interface but each time the result is the same. Also I have shrunk the database log files and turned off Schema replication (read that this can cause an issue).
Any help much appreciated.
Sean
