What are the challenges you face when working across database platforms? Take the survey

Backup and restore between SQL 2005 and SQL 2000

hungnnhungnn Posts: 18
edited October 24, 2008 5:10AM in SQL Backup Previous Versions

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?



  • Options
    peteypetey Posts: 2,358 New member
    You cannot restore a SQL Server 2005 database on to a SQL Server 2000 instance. You can do the reverse i.e. restore a SQL Server 2000 database on to a SQL Server 2005 instance.

    If you want to move to SQL Server 2000 from SQL Server 2005, I think some of the other Red Gate tools may help e.g. SQL Compare, SQL Data Compare etc.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.