http://blogs.technet.com/andrew/archive/2008/11/20/restore-sql-server-to-an-earlier-version.aspxIt’s a simple matter to restore SQL Server backups to later versions, in fact you don’t need to do anything different but what about the other way around? I first got caught out with this&#160; back in the days of SQL Server 7 and 2000, and the basicen-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.technet.com/andrew/archive/2008/11/20/restore-sql-server-to-an-earlier-version.aspx#3157009Thu, 20 Nov 2008 17:40:49 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3157009Secure Citrix Systems &raquo; Blog Archive &raquo; Andrew Fryer&#39;s Blog : Restore SQL Server to an earlier version<p>PingBack from <a rel="nofollow" target="_new" href="http://www.safewordfordforcitrix.com/andrew-fryers-blog-restore-sql-server-to-an-earlier-version">http://www.safewordfordforcitrix.com/andrew-fryers-blog-restore-sql-server-to-an-earlier-version</a></p> http://blogs.technet.com/andrew/archive/2008/11/20/restore-sql-server-to-an-earlier-version.aspx#3157402Fri, 21 Nov 2008 10:09:40 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3157402Jason Cumberland<p>You can also periodically script out the logins using a procedure called sp_help_revlogins that will extract the commands necessary to recreate your logins. &nbsp;It won't capture default DB but a small modification will take care of that. &nbsp;This could be run every night as an instance level recovery tool, kin of handy. &nbsp;Using DBArtisan will even extract the SID for you, so no need to worry about remapping.</p>