As Gail mentioned, mirroring can help. Backups are needed, but so is DBCC. Corruption can flow into backups.

Specialized backups certainly have issues. They're really exports of data, and the importer is responsible for ensuring integrity, but having copies of lookup tables, or other specific (and limited data),...

http://www.sqlservercentral.com/articles/Stairway+Series/72461/

The likely cause if your call to the service might be looking for a password. That would get the .exe to freeze.

Frozen IO doesn't mean consistent. The backup needs to respect transactions.

The job runs under the context of the Agent service or the proxy. Be sure that account has rights. You might log in as that account and then try to...

The only way to check a backup is to restore it.

I have never seen a SQL Server backup fail to restore, unless the file was corrupt. It's a solid process....

I have had a few people I know use mirroring to minimize the downtime. You can do this as well, but be aware that you need to account for the...

Jeff Moden (6/15/2015)

---

The thing that scares me about that is that it worked. Add a mobility unit, a carbon power cell, and some artificial intelligence and holy shades of...

We'll be fine. We have Kung Fury -

I'd agree with Gail and Jeff here.

It looks like somehow the server was shutdown improperly and then files were moved incorrectly. Do you not have any SQL Server backups?

Listen to Gail, but also, what backup files do you have. You mention the full and log backup at midnight, but what else?

From your post, I assume you have:

-...

+1

Jeff Moden (6/11/2015)

---

You just have to remember to be a bit careful with...

Alvin Ramard (6/12/2015)

---

Ed Wagner (6/12/2015)

---

Yeah, and it's been going on...

DanMcClain (6/12/2015)

---

I think its great that Microsft does the early (not always perfect) for us early adopters. We have SQL 2014 in production utilizing Column store index, filetables, and In-memory....