Comprehensive data protection for all workloads
veremin
Product Manager
Posts: 16495
Liked: 1371 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Change TEMP location on backup proxy

Post by veremin » Jan 17, 2018 12:11 pm

Does SqlTempLogPath regkey look like something you're after? Thanks.

frankwijers
Lurker
Posts: 2
Liked: never
Joined: Jan 17, 2018 11:57 am
Full Name: frank w
Contact:

Re: Change TEMP location on backup proxy

Post by frankwijers » Jan 17, 2018 12:21 pm

Look like, yes. Is, no.
The server is installed as a backup proxy, the services available on this machine are Veeam Data Mover Service (VeeamTransportSvc) and the Veeam Installer Service (VeeamDeploymentService).
So there's no "Log shipper service" available on the machine. I already tried adding it and restarting the services and the backup job, but it had no effect. I seem to be missing something.

EDIT: to be exact, it's step 5 in the link you provided.

MariusN
Novice
Posts: 9
Liked: never
Joined: Jun 12, 2017 11:21 am
Full Name: Marius Neumann
Contact:

Re: SQL log backup change temporary folder

Post by MariusN » Jan 19, 2018 9:54 am

Hi there,

I cannot find any official KB Article for this change - is there something I missed?
Also how does this required change on a physical system behave with Veeam Windows Agents?
Because there is no RegistryKey like that.

Thanks in advance
Cheers!
MN

manuel.aigner
Influencer
Posts: 16
Liked: 1 time
Joined: Sep 25, 2017 8:25 am
Full Name: Manuel Aigner
Contact:

Re: Change TEMP location on backup proxy

Post by manuel.aigner » Feb 19, 2018 10:51 am

I have exactly the same issue.
My log shipping server was unable to copy a 200GB transaction log backup file to it's own c: drive before moving it to destination repo, afterwards all further backups of this sql machine fails. The T-Log grows till out of disk space on log-partition. Then the SQL Server halts. :?
That's not optimal. How can we repoint this veeam Temp-Dir on log shipping server. We don't have such big C: drives...

veremin
Product Manager
Posts: 16495
Liked: 1371 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL log backup change temporary folder

Post by veremin » Feb 19, 2018 11:33 am

I have exactly the same issue.
- Have you implemented the referenced regkey?
- Have you implemented it on the SQL machine, not backup server?
- Have you restarted log shipping service afterwards?

manuel.aigner
Influencer
Posts: 16
Liked: 1 time
Joined: Sep 25, 2017 8:25 am
Full Name: Manuel Aigner
Contact:

Re: SQL log backup change temporary folder

Post by manuel.aigner » Feb 19, 2018 2:47 pm

Yes I've. On DB-Server I've repointed the temp folder from C:\ProgramData\Veeam\.... to P:\VeeamLogBackup. That works as expected. But our problem is the log shipping server which stand between of DB-Server and Repository.
Veeam copies the backup file to log shipping servers C:\Windows\Temp. If the BAK file is quite large (in our case more than 200GB) it's impossible because our Sys-Drives only 100GB large.

foggy
Veeam Software
Posts: 17931
Liked: 1512 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL log backup change temporary folder

Post by foggy » Feb 21, 2018 2:00 pm

Currently there's no ability to redirect temp location on the log shipping server.

BGA-Robert
Service Provider
Posts: 60
Liked: 8 times
Joined: Feb 03, 2016 5:06 pm
Full Name: Robert Wakefield
Contact:

Re: SQL log backup change temporary folder

Post by BGA-Robert » Feb 26, 2018 4:43 pm

Yea, storing temp data in the C:\ drive on the Veeam server is not great.
When we first started SQL logs backups, this bit us since the pending logs backup was huge and the C:\ volume on the Veeam server filled.

If you really need to mitigate this, you could create a junction to another volume for that folder.
https://docs.microsoft.com/en-us/sysint ... s/junction

johannesk
Enthusiast
Posts: 53
Liked: 9 times
Joined: Jan 19, 2016 1:28 pm
Full Name: Jóhannes Karl Karlsson
Contact:

Re: SQL log backup change temporary folder

Post by johannesk » Feb 28, 2018 10:40 am

You might also want to consider configuring the SQL server with the 'Compress backups' option, (if it's not configured that way already). That will make the transaction log bacups alot smaller when Veeam triggers them.

Thus you might not need to configure the temp path.

This is the SQL server configuration for compression.

EXEC sys.sp_configure N'backup compression default', N'0'
GO
RECONFIGURE WITH OVERRIDE
GO

yakamoneye18
Enthusiast
Posts: 29
Liked: 1 time
Joined: May 03, 2018 6:20 am
Full Name: Tobias
Contact:

Re: SQL log backup change temporary folder

Post by yakamoneye18 » Apr 08, 2019 1:01 pm

Hey everyone,

a quick question about the temporary location for the transaction log backup: did the default location for this change with Update 4a?
Since the update, we had errors because transcation log backups "took longer than desired log backup interval". This happend always during the same night time, in the same timeframe when the database on this server is copying about 200GB of data from another DB server. Before askin support for it I looked at the logs myself, and I found that before the update, the temporary bak file was saved to c:\programData, and now it is saved on the same disk as the database (drive E:), in a newly created "Veeam" folder (on another DB server, the files are saved in the backup partition, drive G:). The problem seems to be that the disk is in high usage because of the copy process of the sql server itself, so the transaction log copy process now goes about 100-120 minutes, before the update it was 10-20...

My question: did the default location for the temporary bak file change? And what is the logic for the location (on one server with the DB, on another server on an unused backup partition)?

I will try to force the temp file to another location with the reg key provided here, if this does not solve the problem I will however have to get in touch with support.

Regards,

Tobias

yakamoneye18
Enthusiast
Posts: 29
Liked: 1 time
Joined: May 03, 2018 6:20 am
Full Name: Tobias
Contact:

Re: SQL log backup change temporary folder

Post by yakamoneye18 » Apr 08, 2019 1:09 pm

Okay, even stranger - I just wanted to set the reg key, and I saw that the key is already existent and is set to the new strange location, on both servers. We are only 3 persons in the department who can do this, and they all say they didn't. Is there any explenation why this registry setting is created automatically with Update 4a? And is it safe to remove it if I want to reuse the %alluserprofile% folder?

Gostev
SVP, Product Management
Posts: 24283
Liked: 3328 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL log backup change temporary folder

Post by Gostev » Apr 08, 2019 1:58 pm 1 person likes this post

Yes, the default location did change to the volume with most free disk space - this is documented in the What's New document.

yakamoneye18
Enthusiast
Posts: 29
Liked: 1 time
Joined: May 03, 2018 6:20 am
Full Name: Tobias
Contact:

Re: SQL log backup change temporary folder

Post by yakamoneye18 » Apr 08, 2019 2:12 pm

Hi Anton,

read the What's new several times, and always overread this... Thanks for the hint.

Just to clarify:
- If I delete key, will it reset to the %AllUserProfile%?
- The document says that the process will use the Volume with most free disk space - if later we delete some files and on another disk there now is more free space - will this change at some point? Or will it use the volume with the most free space in the moment of the transportation service installation / job creation?

foggy
Veeam Software
Posts: 17931
Liked: 1512 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL log backup change temporary folder

Post by foggy » Apr 11, 2019 11:51 am 1 person likes this post

Hi Tobias, if you delete the key, it will be re-created and set to the disk with the most free space available at the moment. So if you want to set it to some other folder, you need to do this explicitly. (I think this answers both of your questions.)

Post Reply

Who is online

Users browsing this forum: bretesq, Google [Bot] and 57 guests