Re: Server Migration...

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

Date: Mon, 23 Aug 2004 08:13:51 -0700

Tom,
  Thanks for your answer. But I could be wrong that when I move the
database between server including all Systems Databases, all Logins and DTS
Packages will be moved automatically... or I need to manually transfer all
Logins and DTS Packages?
Thanks
Ed

"Tom Moreau" wrote:

> 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)
  • 2nd Post - Trouble Getting VS.Net 2003 WalkThrough working
    ... the server. ... MSDE either from the Setup or from the SQL2KDeskSP3 execute. ... it does look like some of the sample databases have been ... >> and they directed me to install MSDE and they attached a ConfigSamples ...
    (microsoft.public.sqlserver.msde)
  • RE: Server Explorer & Databases
    ... As for the visual studio's database server explorer, ... oracle, visual studio generally use the OLD DB provider which is for Oracle ... and support of most general funcctionalitis in latest version of Oracle. ... #Server Explorer for Oracle Databases ...
    (microsoft.public.vsnet.ide)
  • Re: 2nd Post - Trouble Getting VS.Net 2003 WalkThrough working
    ... The fact that the other databases exists phyiscally doesn´t mean that they ... can try to connect to SQL Server using OSL or a GUI. ... The Command OSQL ist for the commandline under DOS. ... > this MSDE either from the Setup or from the SQL2KDeskSP3 execute. ...
    (microsoft.public.sqlserver.msde)
  • Re: Seperate Databases and Business Logic.. SQL vs. .NET code?? Design Ideas/Differences
    ... Say a particular shop has a few critical SQL Databases that are not ... it's been stated that we will not server link. ... and reporting and online can accept day- ...
    (microsoft.public.dotnet.framework.aspnet)