Forum Discussion
Best practise for large SQL database Always On
Hi We are planning to implement SQL server Always ON AG to achieve HA for 2 DBs, however the databases are particularly large (Approx 1TB), the bandwidth between two sites is around 50Mbps, there...
Thank you so much for your reply. I have concern regarding hte initial DB sync as the DB sizes are large considering the bandwidth between the two site for SQL alaways on AG if auto seeding is used
What shall be the best option in our scenario please
Thanks and Regards Ben
That's entirely your choice.
If you're patient, I'd stick with the automatic seeding option. But if you don't want to, then send a full back-up over to the secondary site, restore it and then use the join option.
But ultimately, there's no absolutely right or wrong option - which is why SQL Server gives you so many to choose from.
If I were doing this, I'd probably use the automatic seeding and run the process after hours, but as I say, it's your decision.
Cheers,
Lain