SQL Transaction Log behavior after Move from VMs

VMware specific discussions

SQL Transaction Log behavior after Move from VMs

Veeam Logoby WinstonWolf » Fri Jan 29, 2016 11:53 am

Hello ,

I have configured an SQL Server Transaction Log Backup on two VMs in Backup Job A
Then i moved the both VMs to another Backup Job B .
When i then start in Job B on these both VMs the SQL Transaction Log Backup i becomme the following warning :

Failed to prepare guest for SQL Server transaction log backup Details: Job A owns SQL Server transaction logs backup

What can be the Problem ?

Michael
WinstonWolf
Expert
 
Posts: 181
Liked: 4 times
Joined: Thu Jan 06, 2011 8:33 am

Re: SQL Transaction Log behavior after Move from VMs

Veeam Logoby foggy » Fri Jan 29, 2016 1:36 pm

Michael, transaction logs backup for the specific VM can be performed by a single job only, Veeam B&R prevents other jobs from touching the logs of the same VM. By default, there's a 7 days delay until another job will be able to backup logs of this VM. However, if you need to start backing them up immediately, you can create the SqlBackupLogsAgeDaysToSkipLogBackup registry value and set it to 0.
foggy
Veeam Software
 
Posts: 14742
Liked: 1080 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL Transaction Log behavior after Move from VMs

Veeam Logoby WinstonWolf » Sat Jan 30, 2016 6:41 am 1 person likes this post

[PROBLEM SOLVED]

So much thanks for this Tipp , it works like charm ;-)

Perfekt , now my two VMs are in the right Backup Job and the SQL Transaction Log Backup works fine .
WinstonWolf
Expert
 
Posts: 181
Liked: 4 times
Joined: Thu Jan 06, 2011 8:33 am

Re: SQL Transaction Log behavior after Move from VMs

Veeam Logoby firewall68 » Thu Feb 02, 2017 1:50 pm

Hello togehter have the same issue when i split on Job with 2 Machines into 2 Jobs.
Can you please tell me where i can find the registry entry or where exactly i have to set the new entry?
Because right now i get the message that job B hold the Transact Logs of Job A.

Thx in Advance
Regards from Austria (no Kangaroos :) )
Mike
firewall68
Novice
 
Posts: 7
Liked: never
Joined: Wed Jan 04, 2017 1:16 pm
Location: Austria
Full Name: Mike

Re: SQL Transaction Log behavior after Move from VMs

Veeam Logoby firewall68 » Fri Feb 03, 2017 7:41 am

firewall68
Novice
 
Posts: 7
Liked: never
Joined: Wed Jan 04, 2017 1:16 pm
Location: Austria
Full Name: Mike


Return to VMware vSphere



Who is online

Users browsing this forum: No registered users and 14 guests