Timeline for What is the fastest way to make a copy of a 5TB SQL Server DB on the same server without having to fully reinitialize the DB to add it to the AG
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 8, 2021 at 17:50 | vote | accept | Jobs_Done | ||
| Apr 8, 2021 at 16:27 | answer | added | David Browne - Microsoft | timeline score: 5 | |
| Apr 8, 2021 at 15:37 | comment | added | Jobs_Done | @Taryn. I could take a backup of the DB on the 3rd node, but I need that copy of the DB to only have data up to 12:01am. Is there a way to do that with a backups? Actually, now that I think about it, I could use a tranlog backup, and then roll it to 12:01am. | |
| Apr 8, 2021 at 15:12 | comment | added | Taryn | Can you create a copy_only backup of the database on the 3rd node that you restore on that node with a different name? Then you don't have to remove the DB and add it back into to the AG. | |
| Apr 8, 2021 at 15:11 | review | First posts | |||
| Apr 8, 2021 at 17:59 | |||||
| Apr 8, 2021 at 15:09 | history | asked | Jobs_Done | CC BY-SA 4.0 |