title: sql server timeout expired processed pages
body: <p>Getting this error when executing 3 query that automatically backup dan rar backup database file. </p>
  
  <p>This error happens when running about 3-5 minutes.</p>
  
  <blockquote>
    <p>Timeout expired. Processed 10 pages for database 'DB-HO', file 'DB-HO_log' on file 2.</p>
  </blockquote>
  
  <p>Other info :</p>
  
  <ol>
  <li>using SQL Server 2005 on Windows Server 2003</li>
  <li>using VB.net 2005 to execute that query by manually scheduled</li>
  <li>this happen when executing large DB. when executing small DB is no problem at all.</li>
  <li>I've already setup the timeout expired in management studio options : server -> connections -> remote query timeout = 3600 (1 hour)</li>
  <li>i've already setup also the vb.net connection string with 'Connect Timeout:3600;'</li>
  <li>still doesn't solve the problems</li>
  </ol>
  
  <p>Can anyone point me where I should set this timeout things?</p>
  
  <p><strong>update :</strong></p>
  
  <p>Cause I've need this backup to worked. So I've changed the query into store procedure. And that solved my problem for now.</p>
  
  <p>Though still I'm curios why can't I exec heavy query in vb.net side?</p>
  
  <p>And what does this <strong>timeout expired processed pages</strong> means?</p>