Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    2

    Cool Unanswered: Delete data in publisher database

    I have set up a transactional replication to replicate data from database A to B. As the data in database A is just a temporary db, I need to clean up periodically. I have already replaced the delete command in the stored procedure so that delete action will not triggered in subscriber database when I use delete command in publisher database.

    However, using delete command in publisher db will generate a huge txn log that make my drive out of disk space. I can't use 'truncate table' function as the table is participated in replication.

    Anyone has a good idea how to clean up the publisher database?

    thanks,
    P

  2. #2
    Join Date
    Jan 2003
    Location
    London, England
    Posts
    106
    Well...the only option I can think of will be to backup/truncate the log whenever you do batch-deletes.

    Code:
    BACKUP LOG MyNwind 
    WITH TRUNCATE_ONLY
    Be aware though that when doing this the log not be recoverable! Hope this works for you...
    Frettmaestro
    "Real programmers don't document, if it was hard to write it should be hard to understand!"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •