Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
 Posted - 2008-05-21 : 13:15:45
|
| I have a small doubt.Transactional Replication is on.can we able to shrink a transaction logIf so, will it have any effect on performance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-21 : 13:17:03
|
| Yes you can shrink the transaction log when replication is configured, but why would you want to?Shrinking always affects performance. This is why you typically do not do it or you do it in very small chunks at a time.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
|
|
|
replication