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

  • 问题

  • 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!

    2010年10月8日 3:22

答案

全部回复

  • Did you ask similar question in another thread? What kind of replication do you set?
    2010年10月8日 3:39
  • Did you ask similar question in another thread? What kind of replication do you set?

    right. 硬盘要被撑爆了,是否可以手动删除?或者是其它办法?紧急!!!
    2010年10月8日 3:41
  • Can delete old ones but sql will recreate them on next snapshot, better to hold them on bigger disk.
    2010年10月8日 3:46
  • 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.

    2010年10月8日 3:51
  • Not recreate old, will create new files.
    2010年10月8日 3:52
  • 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?
    2010年10月8日 3:56
  • sqlserver会自动删除这些文件.

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

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


    有dba的职位吗(北京的),请联系我 stswordman#hotmail.com
    2010年10月8日 4:32
    版主
  • You never tell what kind of replication you set and how.
    2010年10月8日 12:57
  • You never tell what kind of replication you set and how.

    快照发布
    2010年10月9日 4:03
  • Actually these files can be put anywhere on network.
    • 已标记为答案 Justinq 2010年10月13日 7:18
    2010年10月13日 7:18