Re: Move databases between servers

Yes, I am here.
It is possible to restore master, but it is a complicated process and it
requires some clean-up afterward. The best way to do this is to move the
databases just as you are planning on doing.

--
Keith Kratochvil


"Tarek" <Tarek@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A4FF54A4-6A26-4D46-A298-0134B3CCDA36@xxxxxxxxxxxxxxxx
Hi,
is there someone there?
What I want to do is clone the sqlserver.
Since the logins are in master and operators/agents are in msdb why I
can't
restore all the databases and avoid importing users/operators/dts?
It's very strange there is no possibility to restore also master, msdb and
so on..
Thanks

"Tarek" wrote:

Hi,
please tell me if this is the right way to proceed.
I'm following note 314546.
So I need to:
1) backup/restore the databases.
2) copy the logins (note 246133)
3) if needed follow note 240872
4) move agents/operators
5) move dts packages
Is this the right way?
Where can I find the "official" microsoft documentation regarding
migration?
Thanks again,


"Tarek" wrote:

Hi Keith,
thanks for your fast reply.
I was thinking about something more simple like:
1) shutdown original sql server
2) copy all database and log files to new server
3) start new server
Do you think this will not work? Can I try it or there are some know
problems?

About your solution, can I issue an online backup on the old server and
then
import it?
Instead of detach/attach use backup/restore.

Thanks again,



"Keith Kratochvil" wrote:

You will want to transfer the logins and passwords:

HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q246133

Then you will want to move your databases.
BACKUP and RESTORE and sp_detach_db and sp_attach_db work very well.
Both
are documented within Books Online.

If you move your msdb database you will want to update
originating_server
within the sysjobs table. Change the old server name so that it
matches the
new server name.

--
Keith Kratochvil


"Tarek" <Tarek@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A8B2E822-7EA3-4274-9E36-87441141FA52@xxxxxxxxxxxxxxxx
Hi,
I want to move my databases from an old server to a new one.
We have bought new hardware and installed sqlserver.
New Version is sqlserver 2000 with sp4.
Old version was sqlserver 2000 with sp3.
What is the best way to move those databases (about 20 db's) from
one
server to the new one?
Is there a document or guideline to follow?
Thanks in advance.






.

Relevant Pages

  • Re: Move databases between servers
    ... What I'm trying to do now is to copy master. ... Now I'm reinstalling sql with identical version, and restore all databases ... Since the logins are in master and operators/agents are in msdb why I ... copy all database and log files to new server ...
    (microsoft.public.sqlserver.setup)
  • Re: Please answer my queries for fresh Installation
    ... You can restore MSDB as well as master. ... > SQL Server, It will create Master, MSDB databases. ...
    (microsoft.public.sqlserver.server)
  • Re: Move databases between servers
    ... Tell me why you need to move master, msdb, and model? ... When you restore databases on your other server SQL Server adds ... If you have lots of jobs defined you could try restoring MSDB. ...
    (microsoft.public.sqlserver.setup)
  • Re: AD Disaster Scenario
    ... SYSVOL are stored in the registry. ... > an option to restore AD & Sysvol information without ... > Master Operations ... we moved the roles to one server in each ...
    (microsoft.public.win2000.active_directory)
  • Re: AD Disaster Scenario
    ... 223346 FSMO Placement and Optimization on Windows 2000 Domains: ... 241594 HOW TO: Perform an Authoritative Restore to a Domain Controller: ... Find Servers That Hold Flexible Single Master Operations ... we moved the roles to one server in each domain. ...
    (microsoft.public.win2000.active_directory)