SQL Server backups cannot be restored to older versions directly. Use Export and Import Data-Tier Application for cross-version database migration. Reconfigure permissions, logins, and connection ...

This came up today and I didn't know exactly how to properly do it.<BR><BR>The situation: We were to move a database from a MS SQL 2000 server into our in house MS SQL server and run the restore to ...