Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL 2000 db COPY to different server with SQL2005

Author  Topic 

RuudMiermans
Starting Member

3 Posts

Posted - 2008-04-17 : 05:16:21
how-to-??
i just want a sql 2000 to convert to 2005 ( from physical different servers)
which files do i have to transport, and what is the sequential procedure ??
so the complete cookbook , if you can !

Rudy
( a SQL dba newbie,but averaged Oracle DBA ...)

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2008-04-17 : 06:02:39
The easiest would probably be to take a backup of the 2000 server, copy the backup-file to the 2005-server and then do a restore. If this is for upgrading purposes tyou should run the upgrade advisor first though:

http://www.microsoft.com/downloads/details.aspx?FamilyID=1470e86b-7e05-4322-a677-95ab44f12d75&displaylang=en

--
Lumbago
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-17 : 11:45:57
There are so many posts regarding this. Check out
Go to Top of Page
   

- Advertisement -