how to limit the folder growing that created for SQL replication?

Question

I created one follder for SQL replication, today I found it became very big and a lot of subfolders in it that name include date, and there were many files in it,the file name like *.bcp/*.idx/*.sch.

Can I detele them? I find some folders' name that is few days ago, is it useful? And how can I limit it growing?

Thanks!

Answer 1

Did you ask similar question in another thread? What kind of replication do you set?

Answer 2

Did you ask similar question in another thread? What kind of replication do you set?

right. 硬盘要被撑爆了，是否可以手动删除？或者是其它办法？紧急!!!

Answer 3

Can delete old ones but sql will recreate them on next snapshot, better to hold them on bigger disk.

Answer 4

Can delete old ones but sql will recreate them on next snapshot, better to hold them on bigger disk.

ok, thanks.

But I don't understand why sql recreated the old, I thing only the last version data is useful, the previous ones are useless, it can be deleted after the new one created.

Answer 5

Not recreate old, will create new files.

Answer 6

Not recreate old, will create new files.

ok, how can I make some setting to delete the old ones automatically or limit that folder growing?

Answer 7

sqlserver会自动删除这些文件.

如果你使用snapshot类型的复制,每一次同步都会产生一个全部article数据的文件,量是很大的.

你可以考虑使用transational类型(第一次初始化也会产生全部的数据存放在文件夹里),或者从备份初始化

---

有dba的职位吗(北京的)，请联系我 stswordman#hotmail.com

Answer 8

You never tell what kind of replication you set and how.

Answer 9

You never tell what kind of replication you set and how.

快照发布

Answer 10

Actually these files can be put anywhere on network.