Error While Mirroring .MDF and .LDF Files

Get help for specific problems
Posts: 3
Joined: 23 Oct 2023

kurohqq2

Hey guys,
Hope you doin' well.
I'm a newbie on the solution, so, I have a few doubts.
I tried to make a job to mirror some database files from my system, so, what I did was.
My installation of FFS isn't in english, so I'm translating the error messages too.
• I enabled blocked files copy under: Tools > Options > Copy Blocked Files
• I enabled the Volume Shadow Copy service under Windows Services on both host and target destination (I'm copying from 2 machines that runs on the same network)
When I try to copy those .MDF and .LD files, I have the following errors:
Not possible to read the file
"\\machine-ip\c$\target-directory\file.ldf". ERROR_SHARING_VIOLATION: the file is already being used by another process. [CopyFileEx].
The Volume Shadow Copy Service could not create a snapshot of "\\machine-ip\c$\target-directory\file.ldf". VSS_E_VOLUME_NOT_SUPPORTED there is no support for shadow copies in the specified volume.
[backupComp->AddToSnapshotSet(const_cast<wchar_t*>(appendSeparator(volumePath).c_str()), GUID_NULL, &snapShotId)]

The files I've been trying to copy are .LDF and .MDF files from a SQL Server.
When I try to copy a .docx file that is being used on the target location, the software copies the file normally.
I've tried backing up the files from different SQL Servers and installing FFS on different machines, both, gives me this error.
Am I doing it wrong? Can someone help me?
User avatar
Posts: 4867
Joined: 11 Jun 2019

xCSxXenon

I don't think you can access VSS copies on a remote machine like that
Posts: 3
Joined: 23 Oct 2023

kurohqq2

I don't think you can access VSS copies on a remote machine like that xCSxXenon, 23 Oct 2023, 21:11
Is there a right way to do it or there is no way to do it?
Or I should I do it backwards, running the software on the remote machine?
User avatar
Posts: 4867
Joined: 11 Jun 2019

xCSxXenon

I believe running FFS on the remote machine is the only way to do it, as then it can use the local VSS for copying locked files
Posts: 3
Joined: 23 Oct 2023

kurohqq2

Got it, tested it and it worked.
Thanks a lot for the help and sorry for the trouble.
User avatar
Posts: 4867
Joined: 11 Jun 2019

xCSxXenon

Absolutely no trouble at all! That's what we are here on the forum for