I have an alwayson environment (AlwaysOn AG). Database [UsersDb] in the slave server, His log file is very big . How can I reduce his size(shrink)?
Asked
Active
Viewed 25 times
0
-
Can you let us know just how big - big - is. The size of the database and log files on both nodes will help a lot – Lawrage May 16 '16 at 00:04
-
600 G in both server . Primary and secondary. – itzik Paz May 16 '16 at 00:06
-
The log an databse . Log 600 G data 800 G . – itzik Paz May 16 '16 at 00:07
-
If you have 600GB worth of log files on the primary you should expect 600GB of log files on the secondary. Quite normal. – Lawrage May 16 '16 at 00:39
-
Forgot to ask, do you have a tlog backup job scheduled and how frequently – Lawrage May 16 '16 at 01:14
-
Whatever the log is on the primary the log will be on all of the secondary servers. If this is a problem, approach it from the primary point of view as all actions will be sent to connected secondary servers. – Sean Gallardy May 16 '16 at 13:37