Jeff, This is taken directly from the Microsoft SQL Server Book Online documentation: --------------------------------------
Question: Can you restore a SQL Server 2000 database backup to a SQL Server 7.0 server? Answer: No. The only way to move a SQL Server 2000 database to a SQL Server 7.0 server is by transferring the data using a method such as DTS, bcp, or use of a query between linked servers. -------------------------------------- Question: Can you restore a SQL Server 7.0 database backup to a SQL Server 2000 server? Answer: Yes. Other than the master, model, msdb, and distribution databases, SQL Server 7.0 databases are compatible with SQL Server 2000. -------------------------------------- Thanks, Del ---------------------------------------------------- "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> wrote on 05/12/2004 05:33:37 AM: > Hi, > > We have: > TDP SQL 2.2.1 > TSM 4.1.3.0 Server running on AIX > > Our Database Admin and Windows teams are in the process of upgrading > servers from SQL7 to SQL2000 and appear to have a problem. This is not a > TSM problem as such however, they have asked a question: > > Can we restore a SQL2000 database to a SQL7 server? As mentioned above, > both servers run TDP 2.2.1
