Andy M Mallon - AM²

Databases & Diversity — Checking Integrity

  • Home
  • About Me
    • About Me
    • Contact Andy
  • GitHub Stuff
    • Profile
    • DBA Database
    • Data Blogger Resource Kit
    • Presentation Content
  • Legal Stuff

Month: July 2014

Moving Replication to a new server (without re-snapshotting)

July 8, 2014 Andy 6

At this job, we used transactional replication extensively with dozens of publications pointing at multiple subscribers. We wanted to migrate the publisher without having to re-snapshot all of the publications. This is how we did it.

github logo Github Profile
DBA Database
Data Blogger Resource Kit
Mastodon:
[email protected]

Subscribe via Email

Join 3,540 other subscribers

SSMS Shortcuts

Awards & Programs



Recent Posts

  • Publishing a Code of Conduct isn’t enough
  • How do I prevent a trigger from firing for one process?
  • Querying SERVERPROPERTY() and DATABASEPROPERTYEX() from a view (without knowing magic)
  • What the heck is the SSISDB? Where does it come from?
  • T-SQL Tuesday #143: My favorite short scripts

Archives

Categories

RSS RSS

  • Publishing a Code of Conduct isn’t enough July 13, 2022
  • How do I prevent a trigger from firing for one process? March 8, 2022
  • Querying SERVERPROPERTY() and DATABASEPROPERTYEX() from a view (without knowing magic) December 17, 2021
  • What the heck is the SSISDB? Where does it come from? October 18, 2021
  • T-SQL Tuesday #143: My favorite short scripts October 12, 2021
  • What time is it in Oz? October 5, 2021
  • Stop using sp_hexadecimal & sp_help_revlogin July 6, 2021
  • FAQs about the dissolution of PASS December 28, 2020
  • Closing Time December 8, 2020
  • Multi-subnet availability group, with mixed MultiSubnetFailover support (Part 2) October 6, 2020

Copyright © 2023 | Andy Mallon | am2.co