Backup and restore between SQL 2005 and SQL 2000
I just wonder whether I can use SQL Backup to backup and restore database from SQL Server 2005 Express Edition into SQL 2000 or vice versa. I got the mix of using SQL 2005 and SQL 2000 so I just want to consolidate them and use only one SQL version either 2005 or 2000.
I got two crirital program, one based on SQL 2000 and one based on 2005. If I just want to use only one version either 2000 or 2005, could you please suggest me what I should do?