Thank this author by sharing:
By Doug Elwood,
Scripting Stored Procedures
How to set the default locations for backups, data files, and log files in SQL Server.
This stored procedure move the LDF or MDF to a new location.
SQL Server table backups location
Stored Procedure (or) SQL Script Output to Text File
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.