Log file backup growth (how long's a piece of string...)

Question

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 1

... also the SQL Server Service Account is in the Administrators' group on the server.

Grant Fritchey SSC Guru Points: 398694 More actions · Answer 2

Beatrix Kiddo (9/18/2013)
... also the SQL Server Service Account is in the Administrators' group on the server.

The Agent can be running under a different account. Check that.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 3

Thanks- I did check that, sorry not to be clear!

Ok, when I comment out

+ replace(convert(nvarchar(50), getdate(), 120), ' ',':') + N'.trn'

it works. Huh?

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 4

Ok, I changed it to + REPLACE(REPLACE(REPLACE(CONVERT(varchar,GETDATE(), 20),'-',''),':',''),' ','') + '. (also on that thread I linked to)

instead, and now it works :cool:. So I will have a series of smallish log backup files, rather than one continually growing one, is that right?