KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have one database which contains the most recent data, and I want to replicate the database content into some other servers. Due to non-technical reasons, I can not directly use replicate function or sync function to sync to other SQL Server instances. Now, I have two solutions, and I want to learn the pros and cons for each solution. Thanks! Solution 1: detach the source database which contains the most recent data, then copy to the destination servers which need the most recent data, and attach database at the destination servers; Solution 2: make a full backup of source server for the whole database, then copy data to destination servers and take a full recovery at the destination server side. thanks in advance, George
Tags (comma-separated)
Save Edits
Cancel