#move database

[lockitdownjms-blog]

SQL Server-move a system database or log file.

Help! My temp transaction log is eating up my storage space!

Ok, at least that's why I needed to figure out how to move the tempdb log.

Thanks to google being the vehicle that dropped me off at this site's doorstep:

http://www.databasejournal.com/features/mssql/article.php/3379901/Moving-the-Tempdb-and-Master-Database-in-SQL-Server.htm

To move a system database(example using tempdb)

use master go Alter database tempdb modify file (name = tempdev, filename = 'PathToNewDBLocationf') go

To move a system database transaction log(example using tempdb's log:

use master go Alter database tempdb modify file (name = templog, filename = 'PathToNewDBLogLocationf') Go

[lockitdownjms-blog]

SQL Express/Server-move database

To move a database to a different location(drive, folder,etc):

Right click on the DB name and click detach(option drop connections enabled)

Stop any services which attach to the DB

Move files to the new location(MDF,LDF)

Attach the databases again and point to the mdf files at the new location