Move database from C to D

Here are some instructions I made for a friend. Please note that these instructions were made on a computer where I didn't have access to an SQL Database, so some of the directories could be wrong. If you need more detailed instructions, e-mail my gmail.com account: natesawyer3.

~Nate

1. Download the appropriate SQL Management Studio Express for your operating system, and install it on the Computer with the database on it. [Link]
2. Open SQL Management Studio and log into your server
3. Choose the database you would like to move from the list on the left side file tree
4. Right Click that database and choose “New Query”
5. Type and run the following query: EXEC sp_detach_db 'TailSpin', 'true' (Replace ‘TailSpin’ with your database name)
6. Now go C:\Program Files\Microsoft SQL Server\MSSQL.1\Data\ Copy “tailspin_data.mdf” and “tailspin_Log.ldf” to your new directory on D: drive. (Replace ‘TailSpin’ with your database name)
7. Type and run the following query: EXEC sp_attach_db @dbname = N'dbnamehere', @filename1 = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data \dbnamehere_Data.mdf', @filename2 = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data \dbnamehere_log.ldf' (Don’t forget to replace the two directories, filenames, and database name to the directories, filenames, and database name of your files and database)