Re: Server Migration...

From: Ed (Ed_at_discussions.microsoft.com)
Date: 08/23/04 

Date: Mon, 23 Aug 2004 08:19:07 -0700

Does that mean I need to restore all user databases first and I restore
Master, MSDB, Model. After that, the whole process will also include all
logins and DTS Packages..
Thank you very much and since this is the first time that i will do the
server migration.
Edmund

"Tom Moreau" wrote:

> Just re-reading your post, if you really do want to move everything, then
> you can do either of the following:
>
> Restore master onto the new box and then just tell it to drop all of the
> databases it can't find. Restore each database.
> OR
> Restore the databases to the exact same path as on the original server.
> Then, restore master.
>
> Either way, make sure you then run sp_dropserver and sp_addserer to add the
> new server name.
>
> --
> Tom
>
> ---------------------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
>
> "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
> news:uRqt4$RiEHA.1644@tk2msftngp13.phx.gbl...
> You can restore just the application database but your users may be out of
> synch with the logins. Check out sp_change_users_login in the BOL.
>
> --
> Tom
>
> ---------------------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
>
> "Ed" <Ed@discussions.microsoft.com> wrote in message
> news:9CC2FEFA-E6AD-4735-BC24-631589577C08@microsoft.com...
> After I read all the articles about moving all the Databases between
> servers,
> the best way and the most easiest way to do it is Backup all the databases
> (Systems&Users) and Restore them on the new server. Is that true? If so, I
> am thinking if I restore the databases, I need to retore the Systems
> Databases first or Users Databases first or doesn't matter...
> any suggestion or anything that I need to pay more attention...
>
> Thank you very much
> Ed
>
>

Relevant Pages

  • Re: AS2005 ... what is wrong with it?
    ... What I have seen is that the dev server is *faster* than the prod server ... And does your dev server also have all 6 databases with all these roles? ... When I restore the "PROV" i got approx 20 sec. ... Starting from an empty data folder should show if this theory is true ...
    (microsoft.public.sqlserver.olap)
  • Re: Copying WSS to another Server
    ... the data in sync I back the SQL databases up and restore them to the replica ... It already has WSS installed. ... > on one server and copy it to another for dev/test purposes, ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: AS2005 ... what is wrong with it?
    ... I have 6 OLAP databases on the server. ... When I restore the "PROV" i got approx 20 sec. ...
    (microsoft.public.sqlserver.olap)
  • Re: Exchange DR, what to do
    ... setup blank databases on theDRexchangeserver, ... data out of the RSG, it tries to restore it to the original server, ... the cluster exchange virtual server name was, ...
    (microsoft.public.exchange.admin)
  • Re: Off-Site Duplicate Server Setup
    ... the normal process for databases is backing up the ... backup the backup files to tape/disk/offline/whatever. ... Which is good until restoration when you need to restore the original, ... likely have a live replicated server available. ...
    (microsoft.public.windows.server.general)