{"id":1967,"date":"2026-06-17T20:44:33","date_gmt":"2026-06-17T20:44:33","guid":{"rendered":"https:\/\/www.ultrexstaff.com\/?p=1967"},"modified":"2026-06-17T20:44:33","modified_gmt":"2026-06-17T20:44:33","slug":"cove-backup-failures-ms-sql-file-in-use-errors","status":"publish","type":"post","link":"https:\/\/www.ultrexstaff.com\/?p=1967","title":{"rendered":"Cove Backup Failures \u2013 MS SQL \/ File In Use Errors"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong>Related Ticket:<\/strong> #6220<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Overview<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Cove backups may fail or complete with errors indicating that files (often SQL-related or tax software database\/temp files) are \u201cin use by another process.\u201d<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is most commonly seen with accounting\/tax applications (e.g., Accounting CS), where background database activity interferes with snapshot-based backups.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Symptoms<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">You may see the following in Cove:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Backup completes with errors<\/li>\n\n\n\n<li>Repeated failures on specific files<\/li>\n\n\n\n<li>Error message similar to:\n<ul class=\"wp-block-list\">\n<li>\u201cThe process cannot access the file because it is being used by another process\u201d<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Common file types involved:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SQL database files (.mdf, .ldf)<\/li>\n\n\n\n<li>Temp database files<\/li>\n\n\n\n<li>Application-specific database components (Accounting CS, etc.)<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Resolution<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1 \u2013 Restart Backup-Related Services<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Reset the Windows Backup Engine and VSS services:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>net stop wbengine\nnet stop vss\nnet stop swprv\n\nnet start swprv\nnet start vss\nnet start wbengine\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Notes:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>wbengine<\/code> = Windows Backup Engine (key factor in this case)<\/li>\n\n\n\n<li><code>vss<\/code> = Volume Shadow Copy Service<\/li>\n\n\n\n<li><code>swprv<\/code> = Microsoft Software Shadow Copy Provider<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2 \u2013 Manually Run Backup<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Trigger a manual backup<\/li>\n\n\n\n<li>Confirm successful completion<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3 \u2013 Monitor Scheduled Backup<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Leave auto-backup enabled<\/li>\n\n\n\n<li>Verify next scheduled run completes successfully<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">When to Use This Fix<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Backup errors reference \u201cfile in use\u201d<\/li>\n\n\n\n<li>Files are tied to SQL or database-driven applications<\/li>\n\n\n\n<li>Issue repeats across multiple runs<\/li>\n\n\n\n<li>Manual retries alone do not resolve it<\/li>\n\n\n\n<li>Issue clears after service restart<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Root Cause (Observed Behavior)<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Based on troubleshooting from this case:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The issue is triggered when an application keeps a database file \u201cactive\u201d during backup<\/li>\n\n\n\n<li>Even though VSS is designed to handle open files, something in the backup chain can become unstable<\/li>\n\n\n\n<li>When a disconnect or interruption occurs, related services (especially backup engine components) may get into a bad state<\/li>\n\n\n\n<li>Once this happens, backups continue to fail until services are reset<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">There is no confirmed root cause from N-able, even after reviewing debug logs<br>\u2192 Behavior is intermittent and not fully explained by vendor support<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Key Takeaways<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Often tied to database activity, not just simple file locks<\/li>\n\n\n\n<li>The backup engine (not just VSS) can get stuck in a bad state<\/li>\n\n\n\n<li>Restarting <code>wbengine<\/code> alongside VSS is the critical step<\/li>\n\n\n\n<li>Issue is intermittent and not fully understood by N-able<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Optional Preventative Considerations<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Schedule backups outside business hours when possible<\/li>\n\n\n\n<li>Ensure database-heavy applications are closed overnight<\/li>\n\n\n\n<li>Watch for recurring patterns tied to specific software<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cove backups may fail or complete with errors indicating that files (often SQL-related or tax software database\/temp files) are \u201cin use by another process.\u201d<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[171,124,5,98,120],"tags":[],"class_list":["post-1967","post","type-post","status-publish","format-standard","hentry","category-backup-software-cove","category-command-line","category-it","category-it-knowledge-base-articles","category-windows","post-preview"],"_links":{"self":[{"href":"https:\/\/www.ultrexstaff.com\/index.php?rest_route=\/wp\/v2\/posts\/1967","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ultrexstaff.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ultrexstaff.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ultrexstaff.com\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ultrexstaff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1967"}],"version-history":[{"count":1,"href":"https:\/\/www.ultrexstaff.com\/index.php?rest_route=\/wp\/v2\/posts\/1967\/revisions"}],"predecessor-version":[{"id":1968,"href":"https:\/\/www.ultrexstaff.com\/index.php?rest_route=\/wp\/v2\/posts\/1967\/revisions\/1968"}],"wp:attachment":[{"href":"https:\/\/www.ultrexstaff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1967"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ultrexstaff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1967"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ultrexstaff.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1967"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}