rsync error Device or resource busy (16)

[bdario58]

Hello there,
I'm using rsync on NAS4Free 10.2.0.2 - Prester (revision 2407) to copy some files from a Windows server 2008 with cygwin library
All is fine except for some files which are in locked status.

the command I use is:
rsync -avrzh Administrator@192.168.20.45:/cygdrive/d/DATABASE_SISTEMI /mnt/ZFS-pool/server_20_45_D

the error I get is:
rsync: send_files failed to open "/cygdrive/d/DATABASE_SISTEMI/MSSQL.2/MSSQL/Data/PROFIS3.mdf": Device or resource busy (16)

I get the same error using the command "mv"

Is there any way to copy a locked file?
Thanks so much, any help is appreciated
Best regards
Dario

[Jack Foobar]

mdf is an actual database file. If it's in use, you can't copy it. You have to shut it down first. DB copies with backup software like Tivoli or Acronis or Symantec cost more because they have plugins within the app to soft down/shadow copy the server while it's ripping the database out. This is standard behavior, and the reason why people pay for backup software in the first place. Else everyone would just tar & rsync.

You are only supposed to rsync backup the local backup of the database. Not the live. So you schedule a db backup to a directory, and just back up that directory. You can't mess with the live db.

[bdario58]

Hello Jack,
now I'm looking for a command starting from NAS4Free to stop the windows service.
Thanks so much for your kindly help
Dario