Last night was a classic case. I'm a data analyst ( DBA without the title I guess ) who generally is given the job of making sure backups and/or log shipping run. We use accurev, which I'm just learning as I migrate from our Legacy side of the house. A big build went out which involved a large amount of database work. This is handled by production support developers who are given sysadmin rights on SQL.

I woke up this morning to find that the production sql server had been restarted several times ( probably by the on call Systems/Network person ). Since our SAN doesn't have enough space to keep two copies of the 350GB full backup, my sql job must delete the prior one first. The restarts killed the backup job so we went several hours with no full backup.

I just emailed them that this must stop or we'll all be either in court or jail for exposing hundreds of clients to total loss.