354 reputation
216
bio website josienbraas.nl
location Netherlands
age
visits member for 2 years, 4 months
seen 19 hours ago

Enthusiast programmer!


Jul
12
comment SQL Server 2008 - performing nightly full backups & transaction log shipping, but log file keeps growing
Is the Recovery Model set to FULL? Transaction log backups do not automatically shrink or truncate the transaction log, so it might keep growing. Check out this article.
May
31
revised How large will the Transaction Log backup be?
added some info
May
31
comment How large will the Transaction Log backup be?
@TomTom: so when I do a full backup, the transaction log will be truncated automatically?? Or do you mean that we don't need a transaction log backup after doing a full backup anymore?
May
31
comment How large will the Transaction Log backup be?
Alas, it's Standard Edition. It might be fine to start a new log chain as you describe, because we have third-party full and differential backups. Thanks for the suggestion!
May
31
asked How large will the Transaction Log backup be?
May
30
awarded  Informed
May
22
awarded  Constituent
May
14
awarded  Popular Question
May
13
awarded  Caucus
Apr
25
awarded  Popular Question
Dec
16
awarded  Yearling
Dec
12
comment grant permission
Are you trying to grant permissions on myTable as user dummyRole? Not enough information in the question as it is now to help you further...
Dec
12
revised Solve conflict between affinity mask and I/O affinity mask?
updated the question with the way I solved the problem in the end
Dec
11
accepted Solve conflict between affinity mask and I/O affinity mask?
Dec
11
comment Solve conflict between affinity mask and I/O affinity mask?
Great answer, thanks a lot for your explanation! I will read up on this. It's not an option I configured myself, I just encountered it on one of our machines and wanted to know what's behind it.
Dec
11
revised Solve conflict between affinity mask and I/O affinity mask?
slight edits
Dec
11
revised Solve conflict between affinity mask and I/O affinity mask?
added tag
Dec
11
asked Solve conflict between affinity mask and I/O affinity mask?
Oct
5
awarded  Excavator
Oct
5
revised Why is it a bad practice to allow everyone to use the sa login?
fixed broken link