sql - Joining a database to an Availability Group-error -


i getting "insufficient transaction log data" error when adding database (42gb) availability group. have taken full , transaction log backups on primary server , restored onto secondary, i'm not sure why there insufficient transaction logs.

i suspected maybe due large amount of time takes transfer backup files secondary server , time restore on secondary server, log backup taken insufficient.

anyone have suggestions why i'm getting error?

try shrinking log file before doing restore. also, allow wizard handle full backup, trans backup , restore.


Comments

Popular posts from this blog

wordpress - (T_ENDFOREACH) php error -

Export Excel workseet into txt file using vba - (text and numbers with formulas) -

Using django-mptt to get only the categories that have items -