Timeline for Moving Databases to New Datacenters
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 13, 2017 at 12:42 | history | edited | CommunityBot |
replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
|
|
| Dec 2, 2015 at 20:12 | comment | added | Kin Shah | @Snake_Plissken the overhead is not high .. If you have large number of databases being frequently logshipped, you might see a little contention in msdb..sysjobhistory table (I am talking db more than 100+). I have servers that do logshipping from one country to another every minute running 50+ databases without issues. | |
| Dec 2, 2015 at 20:09 | comment | added | Snake_Plissken | @Kin thank you for the superb answer. Regarding the log shipping, I take it the overhead on the server to do this is not too high? | |
| Nov 27, 2015 at 21:05 | history | edited | Kin Shah | CC BY-SA 3.0 |
added 449 characters in body
|
| Nov 27, 2015 at 21:01 | comment | added | Kin Shah | @MichaelGreen The log retention can be adjusted to take care of the concern of filling up disk. | |
| Nov 27, 2015 at 20:59 | comment | added | Michael Green | What he said. Make sure the log backups are frequent enough to ensure the current database does not fill its disk while in full recovery. | |
| Nov 27, 2015 at 20:58 | history | edited | Kin Shah | CC BY-SA 3.0 |
added 165 characters in body
|
| Nov 27, 2015 at 20:52 | history | answered | Kin Shah | CC BY-SA 3.0 |