title: What would disable a foreign key constraints?
body: <p>I have a database and all the foreign key constraints are disabled. No one went in as disabled them manually. Can SQL Server disable them automatically for any reason? Would a backup or restore turn them off?</p>
  
  <p>How do I go about turning them back on?</p>
  
  <p>We're using SQL Server 2008.</p>