Re: SQL7 / SQL2000 Restore Question

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" <ADSM-L AT VM.MARIST DOT EDU> 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