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)
 Migrate MSDE to SQL

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-05-05 : 14:52:41
Antonio writes "Hi,

I've one app running in Server "X" and it currently uses MSDE 2000, i want to migrate to a Server "Y" that is currently running SQL 2000, the app will continue running in server "X", and the database will be redirected to the new DB server "Y". I know my app can be redirected, so there's no problem redirecting it. Could you please send me the complete procedure (step by step) that i need to change this, i'm not good at SQL but if i have the procedure step by step i know i can do it.

Both are running in Windows 2000 Server in English SP4.
SQL 2000 Standard ED in English with SP 3.

Thanks

Antonio"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-05-05 : 14:58:54
You'll want to use BACKUP/RESTORE or sp_detach_db/sp_attach_db to transfer the user database.

Have a look at this article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071

Tara
Go to Top of Page
   

- Advertisement -