How to Move the Log & Databases for SQL 2005 Express
- 1). Log on to the SQL Server and run the SQL Management Tool by clicking "Start," then "Programs," then clicking on the SQL Server icon, then, if applicable, clicking on the SQL Management Tool icon within the SQL Server folder.
- 2). Right-click on the database whose files and logs you wish to move, and select "Properties."
- 3). Click "Files."
- 4). Under "Data," select "Path" and type in the new location for the database. Under "Log," select "Path" and type in the new location for the log file. Click "OK."
- 5). With the database files and logs moved, click "File," then "Exit" to close the SQL Management Tool.
Source...