Timeline for Create a secondary read-only copy of DB in a different server
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 4, 2013 at 0:20 | comment | added | mrdenny | No real limitations that you need to worry about. You can query it just fine via ODBC. The only limitations are if you want to start doing something like setting up AGs on the subscriber database there's some stuff you'll need to tweak. | |
| Sep 3, 2013 at 20:02 | comment | added | arnprior | @mrdenny Snapshot Replication sounds possible - any limitations at the destination DB using this method (i.e. can the destination DB be queried via ODBC)? | |
| Sep 3, 2013 at 18:32 | comment | added | RLF | The documentation says that SQL Server 2005 SP4 is the minimum supported upgrade path. I do not have personal experience to confirm that. | |
| Sep 3, 2013 at 18:28 | comment | added | Aaron Bertrand | I don't think you need to down-grade the target to use mirroring or log shipping - as long as you understand that you can't fail over and then fail back, you should be able to restore up-level. | |
| Sep 3, 2013 at 18:19 | history | answered | mrdenny | CC BY-SA 3.0 |