This guide is written for SQL Server 2008 R2 and has not been tested on newer/older versions. While I believe the process is broadly the same, please make sure you check in a development environment before you follow this guide for other versions of SQL.
This guide will show you how to change the physical file locations for SQL databases (excluding system databases like master or model). This may be required if faster storage become available or you need to reconfigure your current SQL storage and need to move the files away from it temporarily.
This guide is not intended to be used to move SQL databases to a different server nor should it be used used to move SQL databases to a new instance. It is simply to change the location of back-end SQL database files without changing the SQL instance/SQL server. Continue reading >>