Hi,
Seems to me everyone has glossed over the problems of re-establishing all the security/login settings.
I typically move the datbase is 10 minutes then spend two hours getting all the permissions sorted :-{
This might help:
http://support.microsoft.com/kb/246133Best,
Viv
>I have SQL 2005 Express running on a Windows 2000 server operating system. The computer is going to be retired and replaced with a better machine but it will still run Windows 2000 server. I have never had to move any SQL 2005 databases from one computer to another. In this case, all databases (about a dozen) will need to be moved to the new machine. Can someone point me to an article that gives you step by step instructions and doesn't assme you know anything about this type type of migration/move operation?
>
>Thanks,
