Open up SQL Server Management Studio
Detach the databases
Copy .mdf and .ldf files for the detaced databases to the new server
Attach the databases
Setup security
>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,
>
>Robert
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer