September 10, 2015 at 5:47 am
Can we shrink log file? HA group is implemented in the cluster environment.
September 10, 2015 at 6:30 am
Yes.
As a once-off, after something unexpected happened, shrinking a log is fine. Do not shrink on a regular basis and make sure you've figured out and fixed whatever caused the log to grow in the first place.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 11, 2015 at 12:01 am
If your ans (Yes) about shrink log on HA
1. What sql command to used when HA is online on multiple cluster node
2. Recovery mode is FULL, Log file grow Auto and DB handle huge transaction around 5 million on day, how to control or mitigate log file will not grow enormously
3. What is acceptable frequency shrink the log files.
Regards
Mubashir Hashmi
September 11, 2015 at 1:45 am
Are you backing up the database log frequently in your maintenance plan? How often do you back it up?
Sounds like you have a high volume of transactions, causing the log file to grow.
Regular log backups will assist in freeing up the pre-allocated log size you have created.
September 11, 2015 at 2:55 am
mubashir.hashmi (9/11/2015)
If your ans (Yes) about shrink log on HA1. What sql command to used when HA is online on multiple cluster node
Exactly the same one you use to shrink the file any other time. DBCC ShrinkFile
2. Recovery mode is FULL, Log file grow Auto and DB handle huge transaction around 5 million on day, how to control or mitigate log file will not grow enormously
How often are your running log backups?
3. What is acceptable frequency shrink the log files.
I answered that in my first reply
"As a once-off, after something unexpected happened, shrinking a log is fine. Do not shrink on a regular basis and make sure you've figured out and fixed whatever caused the log to grow in the first place."
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 26, 2015 at 5:21 am
Yes we can shrink the log File on HA (cluster)
Backup log <<dbname>> to disk=’NUL:’
DBCC shrinkfile(<<dblogname>>,10);
DBCC shrinkfile(<<dblogname>>,EmptyFile);
DBCC loginfo
Regards
Mubashir
November 26, 2015 at 5:23 am
Great!!! This works
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply