Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    94

    Unanswered: db refresh which is in replication

    Hi,

    I have a dev database which is actually a replication souce for other dev db.

    I would like to get this dev db refreshed from Prod. what are the steps to stop its replication , load it and reset the replication back please.

    appreciate your reply,

    Thanks,
    Ram.

  2. #2
    Join Date
    Nov 2002
    Posts
    94

    db refresh which is in replication - got it pl confirm

    Hi,

    I got the sequence to refresh primary DB with dumps pl confirm if its correct.

    1. use database
    2. Get the details of db configuration. – get sp_config_rep_agent details
    3. get gen_id details – run dbcc gettrunc to get gen_id details.
    4. stop rep agent with sp_stop_rep_agent
    5. load database from dump.
    6. configure the rep agent back as per details in step 2.
    7. dbcc settrunc(ltm,ignore)
    8. dump tran database with truncate_only
    9. dbcc settrunc('ltm', 'valid')
    10. dbcc settrunc(‘ltm’,’gen_id’, gen_id+1 from setp 3)
    11. on RSSD db rs_zeroltm data_server, database
    12. sp_start_rep_agent database

    Thanks,
    Ram.

Posting Permissions

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