How can I move a database?

Hi
I am having to move a database from one pc to another and would like to know
the best way to do so making sure that users and logins come across as well.
I am using MSDE 2000 Rel A and am moving it from a Windows 2000 pc to a
Windows XP Prof 2002 SP2 machine.
I have sucessfully installed MSDE on the new pc and can view it through
DBAMgr2k.
I need to know how to create the database and pull across all the
properties.
I tried generating an SQL script for all objects but when I tried to run it
on the XP machine (using DBAMgr2k) I received a "Count field incorrect or
syntax error" message.
Any help would be much appreciated.
Thanks
June
Hello,
Please read the article and go ahead based on the steps defined. This help
you to move all the user databases and system databases to new server.
Since you are moving the system databases you will get the Logins, users,
Jobs,... to the new environment automatically.
http://support.microsoft.com/kb/224071
Thanks
Hari
"June Macleod" <junemacleod@.btconnect.com> wrote in message
news:csKdncKr1KVXoD_YRVnyjQA@.bt.com...
> Hi
> I am having to move a database from one pc to another and would like to
> know
> the best way to do so making sure that users and logins come across as
> well.
> I am using MSDE 2000 Rel A and am moving it from a Windows 2000 pc to a
> Windows XP Prof 2002 SP2 machine.
> I have sucessfully installed MSDE on the new pc and can view it through
> DBAMgr2k.
> I need to know how to create the database and pull across all the
> properties.
> I tried generating an SQL script for all objects but when I tried to run
> it
> on the XP machine (using DBAMgr2k) I received a "Count field incorrect or
> syntax error" message.
> Any help would be much appreciated.
> Thanks
> June
>
|||That worked well.
Many thanks
June
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23g60%23WyMHHA.4992@.TK2MSFTNGP04.phx.gbl...
> Hello,
> Please read the article and go ahead based on the steps defined. This
help[vbcol=seagreen]
> you to move all the user databases and system databases to new server.
> Since you are moving the system databases you will get the Logins, users,
> Jobs,... to the new environment automatically.
> http://support.microsoft.com/kb/224071
> Thanks
> Hari
>
> "June Macleod" <junemacleod@.btconnect.com> wrote in message
> news:csKdncKr1KVXoD_YRVnyjQA@.bt.com...
or
>