Moving Databases with SQL Server »
Today I needed to move some databases. Data files, technically, but it's essentially the same concept. Instead of moving both the data file and the log file to another machine, I just moved the data file to the other drive, as having the data files on one drive and the log files on another speeds the access a bit. Everything else is identical to moving from one machine to another.
