February 24, 2015 at 9:49 am
Hi,
I backed up my transaction log file using this:
BACKUP LOG iTest2_AELetters TO DISK = N'nul'
(yes I know this breaks the log chain - it's expected in this intance)
But after I run it my t log is exact same size. I have refreshed many times.
I am using SQL Always On on this DB.
February 24, 2015 at 9:53 am
krypto69 (2/24/2015)
Hi,I backed up my transaction log file using this:
BACKUP LOG iTest2_AELetters TO DISK = N'nul'(yes I know this breaks the log chain - it's expected in this intance)
But after I run it my t log is exact same size. I have refreshed many times.
I am using SQL Always On on this DB.
Backing up the transaction log truncates the log, marks virtual log files as inactive (reusable). It does not shrink the physical log file.
February 24, 2015 at 9:58 am
Oh okay. Thanks Lynn.
February 24, 2015 at 10:17 am
You might read this to ensure you understand: http://www.sqlservercentral.com/articles/Administration/64582/
February 24, 2015 at 11:43 am
More information:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply