Comprehensive data protection for all workloads
OmiFreak
Enthusiast
Posts: 28
Liked: 9 times
Joined: Apr 26, 2011 4:11 pm
Full Name: Bernd Flatz
Contact:

SQL log backup change temporary folder

Post by OmiFreak »

Hello,

We backup SQL transaction log from some bigger servers with Veeam.
Veeam makes a normal SQL transaction log backup to a temporary folder ("C:\Documents and Settings\All Users\Application Data\Veeam\Backup\SqlLogBackup\) first.
With a high amount of logs this could be a problem because C:\ is running out of disk space.
Is there a way to change this path to another drive?

Regards,
Bernd
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL log backup change temporary folder

Post by veremin »

You can set a different folder by using SqlTempLogPath (STRING) regkey on the SQL Server. Thanks.
darren.goobey
Lurker
Posts: 2
Liked: 1 time
Joined: Feb 13, 2015 4:29 pm
Contact:

Re: SQL log backup change temporary folder

Post by darren.goobey » 1 person likes this post

On a SQL Server in "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Veeam\Veeam Backup and Replication" try adding a registry key 'SqlTempLogPath' of type String. And specify a destination path. Important note: do not add "\" to the end of the path! Out of interest what are the size of your SQL transaction log backups for your bigger servers? Did you ever consider using RedGate SQL Backup?
OmiFreak
Enthusiast
Posts: 28
Liked: 9 times
Joined: Apr 26, 2011 4:11 pm
Full Name: Bernd Flatz
Contact:

Re: SQL log backup change temporary folder

Post by OmiFreak »

Thank you for the answer.
I added the key but nothing changed. Do I need to restart something to take this affect?

@darrem: Our biggest SQL server has 300GB logfiles, the log backup itself can go up to 50GB. Never consider RedGate. If possible I want to have all our backup in one software to keep things simple.
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL log backup change temporary folder

Post by veremin »

Just to be sure you've created it on a SQL VM, not a backup server, right?
OmiFreak
Enthusiast
Posts: 28
Liked: 9 times
Joined: Apr 26, 2011 4:11 pm
Full Name: Bernd Flatz
Contact:

Re: SQL log backup change temporary folder

Post by OmiFreak »

Yes on the SQL VM. I tried it under [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Veeam\Veeam Backup and Replication] and [HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\Veeam Backup and Replication]. because there was no Veeam in Wow6432Node.
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL log backup change temporary folder

Post by veremin »

Restart backup log service is necessary inside the guest VM. However, it should happen automatically, once the current log collection interval expires. If that doesn't occur, try to restart the said service manually and see whether it helps or not.
OmiFreak
Enthusiast
Posts: 28
Liked: 9 times
Joined: Apr 26, 2011 4:11 pm
Full Name: Bernd Flatz
Contact:

Re: SQL log backup change temporary folder

Post by OmiFreak » 2 people like this post

After restarting the log service it use the new path.
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL log backup change temporary folder

Post by veremin »

Thank you for the confirmation. Should other help be needed, feel free to ask.
jwmaynar
Novice
Posts: 5
Liked: never
Joined: Apr 10, 2012 11:58 am
Contact:

[MERGED] SQL Log Shipping Temporary Directory

Post by jwmaynar »

I saw on another thread there there is a way to change the directory that Veeam uses to hold logs on the log shipping server. It seems to default to C:\Windows\Temp but what do you need to change in the registry to change that directory?
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL log backup change temporary folder

Post by foggy »

Please review the thread above for details.
jwmaynar
Novice
Posts: 5
Liked: never
Joined: Apr 10, 2012 11:58 am
Contact:

Re: SQL log backup change temporary folder

Post by jwmaynar »

Foggy,

The above thread seem to be about how to change the directory on the SQL server, not the Backup server. I'm looking to change the directory on the backup server that is used as the intermediate destination for the logs before they are more into the backup repository. In our case the SQL servers do not have direct access to our repositories.

Thanks!
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL log backup change temporary folder

Post by foggy »

Right, my bad. However, seems there's no similar key for the case when log shipping server is used.
andreash
Enthusiast
Posts: 46
Liked: 7 times
Joined: Dec 04, 2013 8:13 am
Full Name: Andreas Holzhammer
Contact:

Re: SQL log backup change temporary folder

Post by andreash »

Hi,

trying to implement this onto our SQL Server as well. Could you please detail the location of the registry key and which Service to restart?
I'm afraid there is no VEEAM structure in the Wow6432 Node.

Regards,
Andreas
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL log backup change temporary folder

Post by foggy »

The key depends on the OS, so you can specify the value in both locations, for reliability. The service is called either Veeam SQL Service or Veeam Log Shipper, as far as I can recall.
DeaconZ
Influencer
Posts: 14
Liked: 3 times
Joined: Jul 09, 2010 7:39 pm
Contact:

Re: SQL log backup change temporary folder

Post by DeaconZ »

Trying to do this as well since a large Tlog backup filled up my C drive on the SQL VM. I can't find any service on the SQL or Veeam server named like what is referenced.
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL log backup change temporary folder

Post by veremin »

So, the SQL VM is processed with AAIP enabled and the log job is enabled for it? In the meantime, there is no service inside this VM that looks like Veeam SQL Service or Veeam Log Shipper? Are there any services inside SQL VM which have Veeam as a prefix? If so, what are those services?
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL log backup change temporary folder

Post by foggy »

The exact name of the service is VeeamLogShipper.
DeaconZ
Influencer
Posts: 14
Liked: 3 times
Joined: Jul 09, 2010 7:39 pm
Contact:

Re: SQL log backup change temporary folder

Post by DeaconZ »

Yes. SQL VM's with AAIP enabled and log backups every 60 minutes. There are no Veeam services on the Guest at all.

EDIT: running Veeam v9
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL log backup change temporary folder

Post by foggy »

And do you see the logs being processed in the job stats?
DeaconZ
Influencer
Posts: 14
Liked: 3 times
Joined: Jul 09, 2010 7:39 pm
Contact:

Re: SQL log backup change temporary folder

Post by DeaconZ »

Yes. Here is one from a SQL node in our SharePoint farm.

Code: Select all

1/27/2016 10:16:14 AM :: Performing SQL Server transaction log backup for WSS_Content; User Profile Service Application_SocialDB_c709fb00cc8d46bd92ae55e8fb961990; UPSA Social DB; UPSA Sync DB; UPSA Profile DB; TranslationService_98689d98e5ec41d2b32b6a891faf487e; StateService_90e666d5d2664f82b76aaff676a7682d; User Profile Service Application_ProfileDB_fb005471265141dfb136ec9cbcab0bb3; SP15_Content_fin_corp2016; SP15_Content_MySites; SharePoint_Config; and 18 other databases
EDIT: scratch that, it failed witha message about an agent not reachable. How do I install this agent?
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL log backup change temporary folder

Post by veremin »

Is the SQL VM reachable from the backup server and the account used has required permissions? Thanks.
DeaconZ
Influencer
Posts: 14
Liked: 3 times
Joined: Jul 09, 2010 7:39 pm
Contact:

Re: SQL log backup change temporary folder

Post by DeaconZ »

It was Windows permissions. Thanks.
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL log backup change temporary folder

Post by veremin »

Glad to hear that you've resolved the issue. Should other help be needed, don't hesitate to let us know. Thanks.
lightsout
Expert
Posts: 227
Liked: 62 times
Joined: Apr 10, 2014 4:13 pm
Contact:

[MERGED] SQL Transaction Log temporary location

Post by lightsout »

All,

So with Veeam v9 (and with v8 too), when I do SQL transaction log backups, it puts the files into c:\programdata\veeam\blah\blah on the local machine during the backup process.

The problem is, I've got some huge transaction log backups, so I'll need to expand C: as a one time deal to get the transaction logs shrank. Once the logs are shrunk, this won't be a problem though. There are other drives on the same server, which already have the necessary space.

Is there anyway to redirect the SQL transaction logs to a different local location somehow?
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL log backup change temporary folder

Post by foggy »

Please see above for details on how to do that.
stuladhar
Lurker
Posts: 1
Liked: never
Joined: Feb 19, 2016 2:28 pm
Full Name: Sangeet M
Contact:

Re: SQL log backup change temporary folder

Post by stuladhar »

I Manually Altered the registry [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\VeeaM\Veeam Backup and Replication] .. Here is the screen shot

http://i1305.photobucket.com/albums/s54 ... q2nmf1.jpg

This is done on VM SQL server ... then restart the server after registry update.... this should redirect logbackup L drive rather than C .....
ober72
Veeam Vanguard
Posts: 698
Liked: 136 times
Joined: Jan 24, 2014 4:10 pm
Full Name: Geoff Burke
Contact:

[MERGED] SQL log backup job Temp location

Post by ober72 »

Hi

We are getting an error when running an SQL backup of transaction logs. There is not enough space in the C:\ProgramData\Veeam\Backup\SqlLogBackup\.....bak
This is the temp location where the logs are shipped from to the veeam backup repository.
Can this location be changed somewhere as we can't get more space on the C drive?

Thanks
Geoff Burke
VMCA2022, VMCE2023, CKA, CKAD
Veeam Vanguard, Veeam Legend
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL log backup change temporary folder

Post by foggy »

Geoff, there's a registry value for that, please review this thread for details.
frankwijers
Lurker
Posts: 2
Liked: never
Joined: Jan 17, 2018 11:57 am
Full Name: frank w
Contact:

[MERGED] Change TEMP location on backup proxy

Post by frankwijers »

Hi,
I'm running into a small issue. We are using a backup proxy to offload SQL log backups. I found that these backups have problems, due to disk space limitations. On the backup proxy, I see everything is being written to C:\Windows\Temp, but I want to redirect it to E:\Temp. Can anybody tell me how I can achieve that?

Thanks.
Post Reply

Who is online

Users browsing this forum: Google [Bot], K-SOLdier, kyle.shuberg, robert.vonmehren, Semrush [Bot], ybarrap2003 and 167 guests