StrataFrame Forum » .NET Forums » General .NET Discussion » moving entire SQL server to new hardware?

moving entire SQL server to new hardware?

Keith Chisarik — Mon, 30 Jul 2007 10:31:45 GMT

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?

RE: moving entire SQL server to new hardware?

Greg McGuffey — Mon, 30 Jul 2007 10:31:45 GMT

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!

RE: moving entire SQL server to new hardware?

StrataFrame Team — Mon, 30 Jul 2007 08:56:31 GMT

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 :)

RE: moving entire SQL server to new hardware?

Keith Chisarik — Mon, 30 Jul 2007 08:53:39 GMT

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.

RE: moving entire SQL server to new hardware?

Greg McGuffey — Fri, 27 Jul 2007 21:35:06 GMT

Check out this article:

[url]http://vyaskn.tripod.com/moving_sql_server.htm[/url]

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.