Re: Server Migration...
From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 08/23/04
- Next message: Dan: "Database : I/O error (torn page) detected"
- Previous message: robert_at_cbb: "Maintenance Plans"
- In reply to: Ed: "Re: Server Migration..."
- Next in thread: Ed: "Re: Server Migration..."
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 23 Aug 2004 12:28:04 -0400
If you have restored all of your databases (including master and msdb), then
you won't need to migrate your logins or DTS packages. You may have to
modify the DTS packages themselves, since they may be pointing to the old
server name. Also, you may want to extract all of the scheduled jobs as
scripts and migrate them.
-- 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:0B6F58C8-9D12-4E4C-B8EA-C82FBE07FACC@microsoft.com... 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 > >
- Next message: Dan: "Database : I/O error (torn page) detected"
- Previous message: robert_at_cbb: "Maintenance Plans"
- In reply to: Ed: "Re: Server Migration..."
- Next in thread: Ed: "Re: Server Migration..."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
