August 30, 2005 at 2:53 pm
Hi friends!
I have a new hardware to migrate all databases, engine, jobs, maintenance plans, dblinks and so on. I will install this server With Win2003, SQL2000 SP3, like the old server.
So, the question is, what is the best way to move all the 'SQL Architecture' from one server to the other (New server, not running SQL yet)
I found this on Support page:
http://support.microsoft.com/default.aspx?kbid=314546#top
is this the best way?
Thanks for help
August 30, 2005 at 3:39 pm
Is the old server is going away?
August 30, 2005 at 3:41 pm
Yes... i will replace the old server
August 30, 2005 at 5:31 pm
Martin,
That's just about the best article you'll find. I've used all three methods (detach/attach, export/import, backup/restore) to move databases and they all work. You may get other suggestions for how to move jobs, DTS packages, etc. but you can't go wrong with scripting them out as the KB article describes.
Greg
Greg
August 30, 2005 at 5:53 pm
For logins You can scripts them (using Query Analyser) this will eliminate Orphaned Users section
Amit Lohia
August 30, 2005 at 6:09 pm
Thanks for the information, but what do you think about this article?
http://vyaskn.tripod.com/moving_sql_server.htm
Thanks for the advices...
August 31, 2005 at 7:32 pm
Hello Martin,
The original KB article that you have listed contains good information on how to move your databases, DTS packages and jobs to the new server and it also contains a very good link to a KB Article on how to move the logins. I've used the sp_help_revlogin for a long time without having problems with orphaned users.
thx
debrunkle
Deborah Runkle
September 1, 2005 at 6:29 am
Thanks for the advice, i want to tell everybody that the article i have published (how to move the whole SQL to another HW), works fine on a SQL 2000 SP3 + Analisys services SP3.
Just, stop the services on both servers, copy the entire MSSQL folder to the target, start the service on the target server, run the SP_ADDSERVER and SP_DROPSERVER to re-register with the new name (if u dont rename the new server with the name of the original server) a restart the machine.
Regards.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply