---
title: "Files struck in restoring status - SQL Server R2 2008"  
description: "Files struck in restoring status - SQL Server R2 2008"  
author: "Anonymous User"  
published: 2015-09-26  
updated: 2015-09-26  
canonical: https://www.mindstick.com/forum/33471/files-struck-in-restoring-status-sql-server-r2-2008  
category: "mssql server"  
tags: ["database", "mssql server"]  
reading_time: 2 minutes  

---

# Files struck in restoring status - SQL Server R2 2008

I recently failed over the [databases](https://www.mindstick.com/startup/34/airbyte-the-open-source-platform-simplifying-data-integration-for-warehouses-lakes-and-databases) via mirror and everything went smoothly. When it was time to do a [differential backup](https://www.mindstick.com/forum/161030/what-is-the-difference-between-a-full-backup-differential-backup-and-transaction-log-backup-in-sql), I got an error so I went to take a look. The [error message](https://www.mindstick.com/forum/23174/error-message-the-page-you-are-requesting-cannot-be-served-because-of-the-extension-configuration) is:\

```
The backup of the file or filegroup "DB_Filegroup_Archive" is not permitted because it is not online. Container state: "Restoring" (8). Restore status: 8. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. The backup of the file or filegroup "DB_Filegroup" is not permitted because it is not online. Container state: "Restoring" (8). Restore status: 8.
```

\
BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only [online data](https://www.mindstick.com/news/998/the-verizon-app-may-be-collecting-your-online-data-browsing-history). BACKUP DATABASE is terminating abnormally. Cannot open backup device 'J:\SQL Backups\DB\Differential\DB_Differential_Backup_201508241903.bak'. [Operating system](https://www.mindstick.com/articles/229069/operating-system-development) error 2(The system cannot find the file specified.). VERIFY DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, [parameters](https://www.mindstick.com/articles/87/passing-parameters-in-c-sharp) not set correctly, or [connection](https://www.mindstick.com/articles/13012/what-makes-ethernet-connection-better-than-wifi) not established correctly.Then I went to take a look at sys.database_files and the state_desc is RESTORING. I thought perhaps it was stuck so I attempted to cluster failover the [database instance](https://www.mindstick.com/forum/12723/add-to-exisiting-database-instance-from-mvc-controller) which fixed another issue (SQL Agent schedule not working), but this issue didn't get fixed.\
This is what the [error log](https://www.mindstick.com/interview/34179/how-to-to-create-async-error-log-monitor-in-c-sharp-using-file-system) states:\

```
Filegroup DB_Filegroup_Archive in database DB is unavailable because it is Restoring. Restore or alter the filegroup to be available. Filegroup DB_Filegroup in database DB is unavailable because it is Restoring. Restore or alter the filegroup to be available.I failed it back to the primary site and the files were ONLINE and great, but when it's on the secondary site, it's set back to RESTORING. I don't understand what's going on...
```


---

Original Source: https://www.mindstick.com/forum/33471/files-struck-in-restoring-status-sql-server-r2-2008

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.