question

gjschell avatar image
gjschell asked

alwayson size limit for full data synchronization

Hello, We have to set up AlwaysOn and I have heard that there is some issues when using the Data Synchronization option of FULL and allowing SQLServer to perform the backup and restore of the database and log backups when it comes to LARGE databases. My question is what is considered LARGE for this operation.? Many people have different ideas as to what is a large database size. So anyone have experience or best practices when it comes to database in the size of 400GB when setting up AlwaysOn and doing the synchronization using the FULL option when you get to the Select your data Synchronization preference. We have 15 databases and 3 replicas each to perform the synchronization on and would like to do as much automated as possible instead of all manual backups and restores.

Thanks

alwayson
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
ThomasRushton avatar image
ThomasRushton answered

I'm not aware of any size limitations specifically. One thing to remember to do, though, is to disable transaction log backups for your database while the AG is being set up. (I've been bitten by this a couple of times when setting up Availability Groups...)

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

gjschell avatar image gjschell commented ·

So what was the size of the biggest DB that you allowed it to do the backup and restore to the replicas on its own using the FULL option for Data Synchronization?

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.