How to solve the issue of SQL Server constantly display…

When SQL Server displays “restoring,” it usually means that a database restoration operation is in progress. This could be caused by a few different reasons.

1. Database restoration operations can be lengthy when restoring a large database, as SQL Server will continuously display the restoration status during this time.
2. Parallel restore operations: SQL Server has the capability to perform multiple restore operations simultaneously, but if there are too many restore operations in progress, it may result in them queuing up and showing as in progress.

The solution is as follows:

1. Waiting: Please be patient while the database restoration operation completes. The specific amount of time required will depend on the size of the database and the performance of the server.
2. Check restoration progress: You can use the following query to check the restoration progress:
3. Choose the session ID, command, and percentage complete from the table sys.dm_exec_requests where the command is related to restoring.
4. This will return the session ID, command, and completion percentage of the ongoing restore operation. You can track the progress of the restore operation by checking the percentage.
5. Check for other restore operations: If there are other restore operations in progress, you can either wait for them to complete or adjust the parallelism of the restore operations as needed.
6. Check the error log: you can refer to the SQL Server error log for additional information about the restore operation. The error log may contain more detailed information about why the restore operation failed or encountered issues.

If the above methods do not solve the problem, it is recommended to contact a database administrator or technical support personnel for further diagnosis and resolution.