Copy Database Files While They are in Use with HobocopyPosted: February 26, 2015
Download a copy Hobocopy from GitHub:
After download the zipped file, unzip it to a folder at your choice.
Use the following Powershell script to copy the database files that are in use.
Powershell to copy database files while they are in use
C:\bcp\Hobocopy.exe C:\MSSQL\Data c:\temp\hotcopied\ testdb*
You can attach these files to SQL Server instance to access the database.