title: sliding window scenario - taking partitions offline
body: <p>Is there a way in MS SQL Server 2005 to take a partition / file groups / files offline?</p>
  
  <p>I have a lot of data in certain tables and would like to use the sliding window Scenario:
  <a href="http://msdn.microsoft.com/en-us/library/ms345146%28SQL.90%29.aspx#sql2k5parti_topic24" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/ms345146%28SQL.90%29.aspx#sql2k5parti_topic24</a></p>
  
  <p>Instead of keeping all the data in the first partition, I would like to take the partition (or files or file group if possible) offline and make it unavailable for my queries.</p>