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

SQL log backup change temporary folder

Post by OmiFreak » Feb 16, 2015 8:05 am

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: 16789
Liked: 1410 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL log backup change temporary folder

Post by veremin » Feb 16, 2015 10:01 am

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 » Feb 16, 2015 10:42 am 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
Influencer
Posts: 15
Liked: 2 times
Joined: Apr 26, 2011 4:11 pm
Full Name: Bernd Flatz
Contact:

Re: SQL log backup change temporary folder

Post by OmiFreak » Feb 16, 2015 3:23 pm

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: 16789
Liked: 1410 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL log backup change temporary folder

Post by veremin » Feb 16, 2015 3:37 pm

Just to be sure you've created it on a SQL VM, not a backup server, right?

OmiFreak
Influencer
Posts: 15
Liked: 2 times
Joined: Apr 26, 2011 4:11 pm
Full Name: Bernd Flatz
Contact:

Re: SQL log backup change temporary folder

Post by OmiFreak » Feb 16, 2015 4:03 pm

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: 16789
Liked: 1410 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL log backup change temporary folder

Post by veremin » Feb 17, 2015 11:02 am

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
Influencer
Posts: 15
Liked: 2 times
Joined: Apr 26, 2011 4:11 pm
Full Name: Bernd Flatz
Contact:

Re: SQL log backup change temporary folder

Post by OmiFreak » Feb 23, 2015 11:27 am 2 people like this post

After restarting the log service it use the new path.

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

Re: SQL log backup change temporary folder

Post by veremin » Feb 25, 2015 8:48 am

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 » Jul 27, 2015 2:27 pm

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: 18158
Liked: 1542 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL log backup change temporary folder

Post by foggy » Jul 27, 2015 2:46 pm

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 » Jul 27, 2015 5:35 pm

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: 18158
Liked: 1542 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL log backup change temporary folder

Post by foggy » Jul 28, 2015 9:45 am

Right, my bad. However, seems there's no similar key for the case when log shipping server is used.

andreash
Enthusiast
Posts: 40
Liked: 5 times
Joined: Dec 04, 2013 8:13 am
Full Name: Andreas Holzhammer
Contact:

Re: SQL log backup change temporary folder

Post by andreash » Sep 24, 2015 3:13 pm

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: 18158
Liked: 1542 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL log backup change temporary folder

Post by foggy » Sep 24, 2015 3:55 pm

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 » Jan 27, 2016 1:34 pm

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: 16789
Liked: 1410 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL log backup change temporary folder

Post by veremin » Jan 27, 2016 2:03 pm

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: 18158
Liked: 1542 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL log backup change temporary folder

Post by foggy » Jan 27, 2016 2:18 pm

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 » Jan 27, 2016 3:09 pm

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: 18158
Liked: 1542 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL log backup change temporary folder

Post by foggy » Jan 27, 2016 3:17 pm

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 » Jan 27, 2016 3:24 pm

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: 16789
Liked: 1410 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL log backup change temporary folder

Post by veremin » Jan 27, 2016 4:36 pm

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 » Jan 27, 2016 5:16 pm

It was Windows permissions. Thanks.

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

Re: SQL log backup change temporary folder

Post by veremin » Jan 28, 2016 11:53 am

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: 218
Liked: 57 times
Joined: Apr 10, 2014 4:13 pm
Contact:

[MERGED] SQL Transaction Log temporary location

Post by lightsout » Feb 04, 2016 6:16 pm

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: 18158
Liked: 1542 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL log backup change temporary folder

Post by foggy » Feb 04, 2016 8:50 pm

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 » Feb 19, 2016 2:51 pm

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
Service Provider
Posts: 511
Liked: 72 times
Joined: Jan 24, 2014 4:10 pm
Full Name: Geoff Burke
Location: CANADA
Contact:

[MERGED] SQL log backup job Temp location

Post by ober72 » Mar 22, 2016 9:55 pm

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
Veeam Certified Architect

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

Re: SQL log backup change temporary folder

Post by foggy » Mar 23, 2016 10:09 am

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 » Jan 17, 2018 12:00 pm

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: No registered users and 21 guests