Re: Move databases between servers

Keith,
is there any microsoft documentation about cloning sqlserver databases
including system db's (master, msdb, tempdb, model).
Thanks again.

"Tarek" wrote:

Hi Keith,
thanks for your replies.
What I'm trying to do now is to copy master. I think this is less risky
because I'm sure I will not loose any login or dts or operators... I
encountered a problem because two sqlserver versions are different (old is
with sp3, new is with sp4).
Now I'm reinstalling sql with identical version, and restore all databases
starting with master. I will do something like:
1) stop sqlserver services
2) start in single user mode
3) restore master
4) restore all databases
5) install sp4
I hope this works.



"Keith Kratochvil" wrote:

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: 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: Move databases between servers
    ... Without them SQL Server will not ... is there any microsoft documentation about cloning sqlserver databases ... encountered a problem because two sqlserver versions are different (old ... "Keith Kratochvil" wrote: ...
    (microsoft.public.sqlserver.setup)
  • Re: select from one db only
    ... Those databases are available to anyone who can login to the server because ... You should never remove guest from master ...
    (microsoft.public.sqlserver.security)
  • Re: Move databases between servers
    ... It is possible to restore master, but it is a complicated process and it ... databases just as you are planning on doing. ... 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)