Jobs stopped working / database wont backup [ms sql 05] **Resolved**

[simmo]

Ok, lets start at the top.
Hurricane hits, server room goes away (but servers stay safe), servers get moved to a datacenter.
As far as the servers are concerned, every thing is the same, only the firewall changed, and not by much.

Now for the part I need help with:

I noticed jobs that I had scheduled stopped running... most were just ones that called stored procs at certain times. I recreated the jobs, and bam, all is well...

except the backups.

I recreated the maintenance plan from scratch and everything... they run, or say they do, as scheduled but they do not create any .bak or .trn files...

so, my questions are:
Why the hell did they stop working?
How can I get my backups working again, I don't want to back them up by hand every night 

[simmo]

:cry:

[wrack]

Sorry for not being able to reply earlier Simmo. I have never seen this behaviour before as moving machines just doesn't stop them doing it.

Kinda stupid question but, is there enough disk space left for backup? Is the backup trying to save file by using the machine name or ip address? Could anyone of those be changed?

[simmo]

No such thing as a stupid question

There is enough space, and I'm backing up manually now.

Its saving to itself, by name, and the ip didn't change.

[simmo]

all fixed

I still don't know what happened in the first place, but I was just going to delete them all and start over. I started getting errors that it couldn't delete and after tracking that down it seems there were some records in the system tables msdb.dbo.sysdbmaintplan_jobs & msdb.dbo.sysdtspackages90 (there was another in there somewhere) that were referencing objects that didn't exist anymore and it was bombing out.
After deleting those records, deleting the existing maint plans and rebuilding them, all ran fine. (There is a slight issue with modifying existing ones, and MS has a long process to work around it, but its faster to just delete them and start over (flushing the bad records if necessary)).

 

[wrack]

Ahh glad that u got that sorted out. Kinda siomethin I would have never thought to look but then again I never came across a problem like that...