Never delete. On move, set enddate instead, and copy to new location with startdate=enddate+1. Add date filter to queries.
_____________________________________________________
Microsoft Certified Master: SQL Server 2008
XDetails Addin - for SQL Developers
blog.sqlxdetails.com - Transaction log myths