Re: Copy SQL Server 6.5 Database

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 12/13/04 

Date: Mon, 13 Dec 2004 21:52:20 +0100

Hi

You need to do a backup (DUMP) on the old server, copy the file over and
then a restore (LOAD) on the new 6.5 server.
You can do the dump and restore through Enterprise Manager. SQL 6.5 does not
support attach/detach.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Otto@ITP" <OttoITP@discussions.microsoft.com> wrote in message
news:1AA7D978-FACD-4F5F-BE42-A59CBD6D682B@microsoft.com...
> I am trying to copying a version 6.5 database on one serv to another
version
> 6. database on another server. And finally upgrade the 6.5 database to
2000.
> As I have never worked with 6.5, how do I perform the copy? We have to
> perform this step as the current server is dying.
>
> Otto

Relevant Pages

  • Re: Dump/Restore?
    ... >> I level 0 dump of my server. ... > Sorry, I was reading the restore man from my mac, and it was not as ...
    (freebsd-questions)
  • Re: problem creating warm standby on 6.5
    ... I recommend that you use ISQLw and execute DUMP and LOAD ... Or you could run SQLTrace and catch the SQL commands issued by Enterprise ... >>Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Moving a PostgreSQL database from one server to another
    ... it seems those are commands ... > to be typed in at the BASH shell, not inside psql... ... A running server hooks into the db and blocks the dump. ...
    (Fedora)
  • rdump problem
    ... I am trying to rdump from server 2 to server1 and am getting ... rcmd: socket: Permission denied ... dump: Date of last level dump: the start of the epoch ...
    (Tru64-UNIX-Managers)
  • Re: SQL Server 2005 hang up
    ... Tibor Karaszi, SQL Server MVP ... External dump process returned no errors. ... System Idle 99%. ...
    (microsoft.public.sqlserver.server)