title: SQL server : Db start up Validation and check the counts on few table
body: <p>Creating a validation script that can be run against the archive server that confirms that databases are up and online after the refresh(SAN level) is done. The script should be small, quick but checks enough to provide good information.</p>
  
  <p>Example </p>
  
  <ol>
  <li>Is db online</li>
  <li>Does a count of rows for a table inserted into a temp table match the count returned by a select count</li>
  <li>Is the processdate value in the current processdate equal to today – 1</li>
  </ol>