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?

Keith Chisarik

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

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!