Timeline for How can I create a test copy of my production database that is updated daily on SQL Server?
Current License: CC BY-SA 4.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 19, 2018 at 0:03 | history | tweeted | twitter.com/StackDBAs/status/1019734559959678976 | ||
| Jul 17, 2018 at 17:25 | answer | added | user9516827 | timeline score: 0 | |
| Jun 29, 2018 at 10:40 | vote | accept | Patrick Collins | ||
| Jun 28, 2018 at 14:03 | answer | added | Scott Hodgin - Retired | timeline score: 3 | |
| Jun 28, 2018 at 14:01 | comment | added | Patrick Collins | @ScottHodgin Thanks for providing a clear answer. I would accept your answer, expect you replied in the comments. Now it's time for me to go back to the drawing board. | |
| Jun 28, 2018 at 12:42 | history | edited | Patrick Collins | CC BY-SA 4.0 |
explained what "takes ages" means
|
| Jun 28, 2018 at 12:32 | comment | added | Edgar Allan Bayron | you can do pull subscription type of replication. | |
| Jun 28, 2018 at 12:11 | answer | added | Błażej Ciesielski | timeline score: 0 | |
| Jun 28, 2018 at 12:08 | answer | added | Aaron Bertrand | timeline score: 2 | |
| Jun 28, 2018 at 11:48 | comment | added | Kevin3NF | You cannot use "Diff Shipping" as you describe because you would have to Recover the database to make changes during the day, and then you can no longer apply the next DIFF. | |
| Jun 28, 2018 at 11:38 | comment | added | Jacob H | What is "ages"? Backup and restore seems fine here. | |
| Jun 28, 2018 at 11:18 | review | First posts | |||
| Jun 28, 2018 at 12:04 | |||||
| Jun 28, 2018 at 11:16 | history | asked | Patrick Collins | CC BY-SA 4.0 |