Hi,
Can anyone please tell me what are the best practices for maintaining the T-log in transactional replication DB.(P2P)
Regards JakDBA Please Mark this as Answered if this solves your issue or satisfied with the response.
Log backups have no real dependencies on replication as long as the log reader agent keeps running.
It is always a good idea to do frequent log backups to minimize VLF growth.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941