Aug 092013
 
delete databases
where  not exists (
  select a_recovery_strategy
  from   backups
  where  your_job_depends = on_it_working
  or     you_may_find_the_job = not_existing
);

Of course, it's a better strategy to put backups and a recovery plan in place than going 
around deleting databases without these. If you're not going to do this you'll save some
pain in the long term just getting rid of them now though!

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)