Re: How can I move a database?

That worked well.

Many thanks

June


"Hari Prasad" <hari_prasad_k@xxxxxxxxxxx> wrote in message
news:%23g60%23WyMHHA.4992@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxx> wrote in message
news:csKdncKr1KVXoD_YRVnyjQA@xxxxxxxxx
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






.

Relevant Pages

  • RE: visio 2003 is greedy for memory
    ... I am building a database diagram ... > and each time I am adding a new entity, moving down or up a database ... > I do not have Visual Studio or an old version of Microsoft Visio ... > The new service pack has not fixed that high memory consumption. ...
    (microsoft.public.visio.general)
  • Re: Access 97 to a more powerfull platform!?
    ... Moving to SQL Server is common when a database "outgrows" ... Design problems are far and away the usual reason why a database ...
    (microsoft.public.access.gettingstarted)
  • Re: File Location Changes & Missing Databases
    ... No, it's not moving, it's being copied, and they're not available in the ... Recycle Bin. ... it probably means that your original song got deleted. ... I thought I'd try the database corruption instructions in KB (article not ...
    (microsoft.public.windowsmedia.player)
  • Re: User Permissions disappearing
    ... database and re-adding the users, it still won't let me attach the users to ... server information in security doesn't get updated. ... Here is some good info related to moving dbs and reestablishing permissions ...
    (microsoft.public.sqlserver.security)
  • Re: But a fool with a tool is still a fool
    ... You did say you were going to keep moving your logic into the database. ... You always need some business logic in the app, therefore also putting it in the database is to be avoided. ... You were advocating moving your business logic into stored procs. ... Jim Cooper jcooper@xxxxxxxxxxxxx ...
    (borland.public.delphi.non-technical)
Loading