Re: Server Migration...

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 08/23/04 

Date: Mon, 23 Aug 2004 10:46:21 -0400

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: 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: why>?
    ... On your desktop-- you'll be running SQL Server behind the scenes. ... it isn't risky to allow end users to create databases. ... it is no more risky than giving you the ability to create spreadsheets. ... I'm not saying that Oracle and IBM are going away. ...
    (microsoft.public.excel)
  • Re: Please answer my queries for fresh Installation
    ... Moving SQL Server Databases ... Using WITH MOVE in a Restore to a New Location with Detach/Attach ... Disaster Recovery Articles for SQL Server ...
    (microsoft.public.sqlserver.server)
  • 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: Server Migration
    ... Moving SQL Server Databases ... Moving Databases between Servers ... Using WITH MOVE in a Restore to a New Location with Detach/Attach ... Disaster Recovery Articles for SQL Server ...
    (microsoft.public.sqlserver.server)