Comprehensive data protection for all workloads
BHickok
Lurker
Posts: 1
Liked: never
Joined: Dec 30, 2011 3:03 pm
Full Name: Bob Hickok
Contact:

Re: Jobs missing

Post by BHickok » Apr 15, 2012 6:28 pm

I have the same issue. All jobs moved to SureBackups, appear corrupt if I try to open their properties as they are. Just installed the latest Veeam v6 SP about 2 weeks ago.
Right in the last few days of tax season, so dozens of workers at 24/7 so not the best time to have backups and replication cease. Hoping the PowerShell script you describe will get it all fixed quickly and easily.

clarkus978
Lurker
Posts: 1
Liked: never
Joined: May 08, 2012 9:57 pm
Full Name: Clark Edwards
Contact:

All Backup/Replica Jobs Removed

Post by clarkus978 » May 08, 2012 10:36 pm

[merged]

This is the second time this has occurred...

The jobs will run fine for months, but today I opened Veeam to make a configuration change...all the jobs go missing. Last time this happened I recreated all of the jobs, but I don't want this to happen for a third time.

If I look under backups, all of my jobs are still there and it shows the creation time, etc. It shows the same for my Replica jobs under Replicas.

Where are my jobs going? Is there a way to re-import them? Can I create a new job and point it to the backup/replication files?

Thank you

Platform1
Influencer
Posts: 13
Liked: never
Joined: Jul 19, 2011 12:14 pm
Full Name: Scott Cooney
Contact:

Re: Jobs missing

Post by Platform1 » May 14, 2012 10:05 am

Has this been added to the sticky 'known issues' thread yet? It's happened to us twice on different backup servers and Veeam CS have informed us it is a bug due to be fixed in the next patch. I'd be interested to know when that's coming out?

The solution which worked was provided by customer service, is as follows:

1. Make a backup of Veeam DB
2. Stop all Veeam services, open MS SQL Management Studio and execute this script against the Veeam DB:

Code: Select all

GO
IF OBJECT_ID ('SbJobTR', 'TR') IS NOT NULL
   DROP TRIGGER SbJobTR;
GO
CREATE TRIGGER SbJobTR
ON [dbo].[BJobs]
FOR UPDATE AS
if exists(select * from BJobs, inserted, deleted where ((BJobs.id=inserted.id) AND (inserted.type = 3) AND (deleted.type <> 3)))
begin
   raiserror ('MUTATED TO SB JOB!', 16, 1)
   rollback
end
GO
Rerun the job to test.

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

Re: Jobs missing

Post by Gostev » May 14, 2012 10:58 am

There will be no next patch, but next release only - sometimes within 1 month from now.

Tanako
Lurker
Posts: 1
Liked: never
Joined: Mar 13, 2012 10:09 am
Full Name: Tanako
Contact:

Re: Jobs missing

Post by Tanako » May 30, 2012 5:13 pm

Hi all. If someone have few jobs like me, I've solved the problem as follows:

1- Make a backup of Veeam DB
2- Open Veeam SQL DB with MS SQL Management Studio
3- Open dbo.BJobs table
4- Inside you will found the missed jobs. Set type field on 0
5- Yours jobs will apear at Veeam Jobs screen but you will need to reactivate "Run the job automatically" at the schedule tab and choose again the storage options

Sethbartlett
Expert
Posts: 282
Liked: 25 times
Joined: Nov 10, 2010 6:51 pm
Full Name: Seth Bartlett
Contact:

Re: Jobs missing

Post by Sethbartlett » May 30, 2012 8:22 pm

There is also a powershell script that will correct the Job options from your job logs so you do not have to re-do your settings.
Skype: Sethbartlett88 - Make sure to label who you are and why you want to add me ;)
Twitter: @sethbartlett
If my post was helpful, please like it. Sometimes twitter is quicker to hit me up if you need me.

Post Reply

Who is online

Users browsing this forum: Google [Bot], Karinne, Pavel.Tyurin and 51 guests