SQLServerCentral / SQL Server 2008 / SQL Server 2008 High Availability / Restore non replicated UAT db into it's replicated PROD one / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 06:51:10 GMT20RE: Restore non replicated UAT db into it's replicated PROD onehttp://www.sqlservercentral.com/Forums/Topic1419022-1549-1.aspxjus make sure about your server names..!Tue, 12 Feb 2013 10:17:59 GMTpenu.v8Restore non replicated UAT db into it's replicated PROD onehttp://www.sqlservercentral.com/Forums/Topic1419022-1549-1.aspxHi,We currently have one of our PROD databases being replicated. Changes to schema/data have been made in UAT environment(which isn't replicated db) and we'd like to restore a UAT database backup into the PROD one to migrate these changes. We're not concerned with losing data/etc in PROD, the UAT will become PROD, I'm just concerned about how this affects and potentially breaks replication.How will this affect replication, or what issues/steps do I need to consider?Thanks,KyleTue, 12 Feb 2013 08:59:59 GMTkyledarrenhanson