Re: Moving databases from sql 7.0 server to a sql 2000 server

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Jasper Smith" <jasper_smith9@xxxxxxxxxxx>
Date: Tue, 1 Nov 2005 16:15:12 -0000

You can't use the upgrade wizard but you can use the Copy Database
Wizard,backup/restore or detach/attach. See the following links

HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?kbid=314546

INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071

INF: Understanding and Troubleshooting the Copy Database Wizard in SQL
Server 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274463

You will also need to sort out the logins on the new server

INF: How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246133
PRB: User Logon and/or Permission Errors After Restoring Dump
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q168001
INF: How to Resolve Permission Issues When a Database is Moved Between SQL
Servers
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q240872
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274188

--
HTH

Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

"Chris" <chris@xxxxxxx> wrote in message
news:76CD05FC-DB0E-4AE4-A386-107B06EC0610@xxxxxxxxxxxxxxxx
> Thanks in advance for any assistance. What I have to do is move
> several sql 7.0 databases from one server to a new sql 2000 server.
> Upgrading the existing sql 7.0 server is unfortunately not an option.
> Can I use the SQL server Upgrade wizard to do this even though it says
> export server 6.5? After the move I will be able to change the machine
> name and Ip address to match the same as the old sql 7.0 server if that
> is an issue. Thanks again.
>
>
> Chris
>
>
>

.

Prev by Date: Re: Can both SQL 2000 and 2005 exist on the same Windows 2000 Server
Next by Date: Re: Moving databases from sql 7.0 server to a sql 2000 server
Previous by thread: Re: uninstall/install seqnence SQL 2005
Next by thread: Re: Moving databases from sql 7.0 server to a sql 2000 server
Index(es):
- Date
- Thread

Relevant Pages

RE: WSS install locked into MSDE DB - Can not install for SQL Serv
... For the MASTER database ... Althought we change the Configuration Application pool several times ... interface BUT they appear to be MSDE databases and not SQL Server databases. ...
(microsoft.public.sharepoint.windowsservices)
Re: How to Replicate an SQL Server 2000 Database
... actual server name) enterprise manager should associate the database with the ... Looking for a SQL Server replication book? ...
(microsoft.public.sqlserver.replication)
Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
... I have had quite a number of clients that used a SAN for a database server and suffered significant performance problems because their underlying SAN infrastructure was a huge stripe across many drives. ... By application files I mean the binn folder which contains the sql server executable among other things. ...
(microsoft.public.sqlserver.setup)
Re: Where can I find my detached database
... The data file should be in your SQL Server Data folder. ... No chance SSMS to drop a database when you detach it. ...
(microsoft.public.sqlserver.server)
Re: SQL Server 2005 Express Remote connection
... I have also deleted the login for Fred from the list of users for my ... So Fred no longer exists as a login or as a user in the SQL Server setup. ... the database? ...
(microsoft.public.sqlserver.server)