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 |
|
rajkumarrai_bis
Yak Posting Veteran
78 Posts |
 Posted - 2013-11-20 : 09:58:53
|
| Is there a way in SQL 2008 R2 wherein we can direct a Table log details in a particular LDF only.Actually we are planning for CDC but given DB Log files size is huge.we want that CDC scans only particular LDF file and not entire LDF files of the DB. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-11-20 : 12:33:55
|
| That is not possible. Put the table into its own database if you require it to have its own transaction log.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Table redirection to a particular LDF file for CDC