Re: Move databases between servers

You are taking the long road to solving your problem.

After master has been restored check what is returned when you query
SELECT @@servername

It is easy to move DTS packages. You can save them as text files and save
them into your new SQL Server. Operators are a breeze to set up, and
moving logins is a simple process using the Microsoft supplied stored
procedures that I referenced in a previous post.

--
Keith Kratochvil


"Tarek" <Tarek@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B080FDF6-BFE6-468C-A798-8C3A7A61CF0D@xxxxxxxxxxxxxxxx
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.


.

Relevant Pages

  • 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
    ... I have restored master and I'm attempting to restore system databases (msdb, ... I checked the servername and it's still the old one. ...
    (microsoft.public.sqlserver.setup)
  • Re: Rebuilt master, whats next?
    ... one thing remains unclear to me: what will happen when I restore ... master then start the server and user databases aren't where they ... Will the references to them in master be automatically ...
    (microsoft.public.sqlserver.server)
  • Re: Server Migration...
    ... If you have restored all of your databases, ... Columnist, SQL Server Professional ... Does that mean I need to restore all user databases first and I restore ... Master, MSDB, Model. ...
    (microsoft.public.sqlserver.server)
  • Re: Move databases between servers
    ... finally I think I was able to do the restore of all my databases. ... The only thing is that in master there's the old servername. ... Execute the RESTORE DATABASE statement to restore the master database ...
    (microsoft.public.sqlserver.setup)
Loading