+5Sql always on Full backup being taken from primary server but log backup being taken from standby server at every 15 minutes .Job finished succesfully but.
This causes problems in log shrink and sql log folder overgrowing
How do I ensure that the log backup is taken from the Primary SQL. server
Best answer by Sunil
This backup preference can be configured from SQL side.
In SQL management studio, open AG properties and set backup preference. We use the preference set here to run backups. If you set this to Primary, the log backups also will run from the Primary replica.
Please try this and let us know how it goes.
Thanks,
Sunil-
+13Hi
You can set the primary replica as the preferred for running backups. This will force the log backups to run on the primary replica.
Thanks,
Sunil-
+5Hİ
How can i do that. full backup taken from primary but log is taken by secondary .i want to take log backup from primary
on configuration tab 1 is already set primary
+13This backup preference can be configured from SQL side.
In SQL management studio, open AG properties and set backup preference. We use the preference set here to run backups. If you set this to Primary, the log backups also will run from the Primary replica.
Please try this and let us know how it goes.
Thanks,
Sunil-
+5Hi
after that change i saw sql log backup on Management studio.thank you taken from primary 😀
but Log folder size stil same ( not shrink )
do i need any setting for log folder shrink size ?
+13We do truncate the logs as long as the option “Do Not Truncate Log” is not selected. However, I’m not sure if there is a delay from SQL side to free up the space. It may still reserve the log file space though it’s free.
Thanks,
Sunil-
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
