By Keith Chisarik - 7/27/2007
I spent the past 1.5 days on the phone with MS trying to get our SQL Server stable, no luck. I am not a DBA so I have never moved an entire server from one box to another and I cant seem to find any good articles on how to do this. Anyone that can give me a push in the right direction will be my hero. I have only about 20 databases for various projects.
Do I have to move the system databases or can i just migrate the user databases to the new server?
Anything special when moving the Strataframe db?
|
By Greg McGuffey - 7/27/2007
Check out this article:
http://vyaskn.tripod.com/moving_sql_server.htm
Also, I have somewhere a script that can be used to move users from one server to another. This is handy if you need to move just a subset of the databases, not the whole enchilada. Let me know if you need that.
* Logins are stored in master, and they are assigned a user id by sql that is referenced internally. Thus, when you move a database, the users assigned to that database will be referencing the guid from the old database and it will not work. This is even if the user name is the same. You have to then manually remove the users from the just moved database, then add the logins to the new server, then add them back to the database. The script I have somewhere actually will move users from one server to another, thus the database will not need to be messes with at all.
|
By Keith Chisarik - 7/30/2007
Thanks Greg, that worked well. I am up and running on the new SQL box this morning.
Since it is just an internal server, I didn't sweat the login issues, we just manually replaced them.
|
By StrataFrame Team - 7/30/2007
Glad you got them running  I didn't realize that the users were all stored in master... when we move a DB from one server to another, we generally either back it up and restore it or just detatch it and re-attach it to the new server and recreate the logins. Good article Greg
|
By Greg McGuffey - 7/30/2007
Yep, I usually just manually replace the users also, but once we moved a database with like a 100+ users. A different method was called form 
Glad you got it moved!
|
|