Question on files being used?

[killmasta93]

Describe the bug
The process cannot access the file because it is being used by another process,

• OS and Architecture [e.g. Windows 10 x64, Darwin arm64]
• Backrest Version [e.g. 0.0.0]

Windows server 2022
backrest 1.7.2

Additional context
Error on item: D:\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\xxxxx_log.ldf

[garethgeorge]

If your file is locked by another process backrest won’t be able to read it. Iiuc this is something windows enforces, you should look at recommendations for backing up Microsoft SQL Server and ensuring its files aren’t being written during backup.

This may require some power shell scripting to stop or export your database during backups. I’m going to go ahead and convert this to a discussion since it’s a question.

[killmasta93]

thanks for the reply, i assumed that it would use VSS to shadow copy for mssql ldf but i guess ill do the backup with sqlcmd, then use restic to backup the .bak