Re: restore MSSQL 7 backup to MSSQL 2000?

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 11/19/04 

Date: Fri, 19 Nov 2004 11:29:02 -0600

Migrating from 7.0 to 2000 is fully supported.

You cannot restore or attach a SQL Server 2000 databaes to SQL Server 7. If
you need to move your data from 2000 to 7.0 (or any previous version) you
will need to find another method such as DTS or BCP. 

-- 
Keith
"J Jetson" <JJetson@discussions.microsoft.com> wrote in message
news:FFE80829-23E3-456F-AB95-A3B3761C6F96@microsoft.com...
> Thank you - I have copied databases between servers before, but not
between
> different versions of SQL Server. I was just checking that I wouldn't have
> problems migrating a 7 database to a 2000 version.
>
> Thanks again!
>
> "Keith Kratochvil" wrote:
>
> > You can use BACKUP and RESTORE or sp_detach_db and sp_attach_db to move
the
> > database.  There is lots of "how to" information regarding these
commands
> > available within Books Online.
> >
> > -- 
> > Keith
> >
> >
> > "J Jetson" <JJetson@discussions.microsoft.com> wrote in message
> > news:101335D5-98F5-498F-8D03-7297BABCDBBE@microsoft.com...
> > > There is one lonely database sitting on a SQL Server 7 instance
running on
> > a
> > > Windows 2000 server. I would like to retire that box and put the
database
> > on
> > > the new Windows 2003 server running SQL Server 2000. Can I just copy a
> > backup
> > > of the SQL 7 database and restore it on the SQL 2000 instance? Thanks.
> >
> >

Relevant Pages

  • Re: Optimization of data migration
    ... I read the article and got puzzled by the "source physical file". ... something equivalent when migrating to SQL Server? ... database and copy the data "as is" in a staging database. ...
    (microsoft.public.sqlserver.dts)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Guide for switching to .ADP from .MDB
    ... If I am correct then you are opting for this option in migrating the ... Create an Access database front-end to an SQL Server database back-end ...
    (microsoft.public.access.adp.sqlserver)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)