Re: How can I move a database?

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: Moving SQL Server 2000 to a new machine
    ... In addition to all the CYA advise, you CAN move the system databases. ... Once you've got the new server at SQL2K, SP2, and the physical paths to ... > Recently I was tasked to move our entire SQL Server 2000 to a new server. ...
    (microsoft.public.sqlserver.server)
  • Re: select from one db only
    ... No.He can see those system databases and sample databases because its common ... databases.You can however DENY permissions.For example, ... "Doug" wrote in message ...
    (microsoft.public.sqlserver.security)
  • Re: Move databases between servers
    ... I assume we can backup the system databases (including ... then restore the system databases. ... When you restore databases on your other server SQL Server adds ...
    (microsoft.public.sqlserver.setup)
  • Re: Server Rebuild - What to do?
    ... but as a backup procedure perform a full database backup for ... all databases including system databases before you do any thing. ... COpy the MDF and LDF to a safe location including system databases ... Install SQL Server in same path ...
    (microsoft.public.sqlserver.setup)
  • Re: Server Rebuild - What to do?
    ... but as a backup procedure perform a full database backup for ... all databases including system databases before you do any thing. ... COpy the MDF and LDF to a safe location including system databases ... Install SQL Server in same path ...
    (microsoft.public.sqlserver.setup)
Loading