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
Microsoft está realizando una encuesta en línea para comprender su opinión del sitio web de Msdn. Si decide participar, se le presentará la encuesta en línea cuando abandone el sitio web de Msdn.
¿Desea participar?