Re: Server Migration...
From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 08/23/04
- Next message: Josh: "Schema"
- Previous message: Ed: "Re: Server Migration..."
- In reply to: Ed: "Re: Server Migration..."
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 23 Aug 2004 11:20:02 -0400
The logins are in the master DB and the DTS packages are in msdb. If your
intent is to move everything, see my comments in my follow-up note.
-- 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:28D506EC-9D2F-4FA4-A6E7-2B3DDA356459@microsoft.com... 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 > >
- Next message: Josh: "Schema"
- Previous message: Ed: "Re: Server Migration..."
- In reply to: Ed: "Re: Server Migration..."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
