Any program must be stopped to move item
Locate MDF and LDF Database
Files:
Database_name_Data.mdf - for .MDF
Database_name_log.ldf - for .LDF
Run this SQL script
ALTER DATABASE AnimalWorks
MODIFY FILE ( NAME = AnimalWorks_Data,
FILENAME = 'E:\New_location\AdventureWorks2014_Data.mdf');
GO
ALTER DATABASE AnimalWorks
MODIFY FILE ( NAME = AdventureWorks2014_Log,
FILENAME = 'E:\New_location\AdventureWorks2014_Log.ldf');
GO
This creates a separate drive with suffiecient disk space to store the file.
Did I solve your question or was that useless? Sorry, new to SQL.