Viewing 4 posts - 1 through 4 (of 4 total)
OK Manged to do it on the Test environment!
I had to run more than once the T-Log backup plan, before the shrink worked!
Thanks for all your help
November 13, 2013 at 4:28 am
I did a T-Log Back and Shrink in my Test environment Here are the Details:
T-Log before Backup 17,943,808 KB
T-Log After Backup 17,943,808 KB
Backup File: 4,188,116 KB
After shrink using (DBCC SHRINKFILE...
November 13, 2013 at 4:03 am
Very Good article indeed!
I will do some testing on a TEST Mirror environment.
Will create a Maint Plan for Log Backup and then will shrink the file.
[highlight=#ffff11]DBCC SHRINKFILE (N'Migrate_log' , 1024)[/highlight]
This...
November 13, 2013 at 3:56 am
I have did manual backup of the Log file (not regular) but still did not shrink.
Should it shrink if i setup daily T-Log backups even if in mirrored scenario like...
November 13, 2013 at 3:02 am
Viewing 4 posts - 1 through 4 (of 4 total)