Monday, May 12, 2008

Moving SQL Server Databases

This is something that I've had to do a lot lately since we are migrating to a larger HA architecture here at work. This article gives a quick list of dos and don'ts to make your next SQL Migration go smoother.

Moving a Database


Here is also a direct link to the Microsoft kb referenced in the above article, this one tells you how to move users from one server to a new server without needing to recreate them and use sp_change_users_login. Check it out here.