Restore non replicated UAT db into it's replicated PROD one

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » Restore non replicated UAT db into it's...

Restore non replicated UAT db into it's replicated PROD one

Rate Topic

Display Mode

Topic Options

Author

Message

kyledarrenhanson

Posted Tuesday, February 12, 2013 8:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 6:07 AM
Points: 2, Visits: 32

Hi,

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,
Kyle

Post #1419022

penu.v8

Posted Tuesday, February 12, 2013 10:17 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 02, 2013 12:37 PM
Points: 19, Visits: 93

jus make sure about your server names..!

Post #1419083

« Prev Topic | Next Topic »

Permissions