main office/domain with a local SQL server on the domain, users connect using ODBC connection w/ windows auth 2nd company/domain at a remote location, people vpn (windows pptp) to access file shares ...

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 ...