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 is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?