I am trying to figure out the proper procedure to overwrite a database with a backup of a database created on a different server. The backup has an identical schema, full text indexes, stored procs, etc. The only thing that differs is the data. The user table current replicates to another database, so I need to restore this database while maintaining this replication. Any tips on how I can do this?
Thanks in advance for your assistance!