When SQL Server restores a database, you are prompted to resolve the backup device cannot be opened (device error or device off) _mssql

"Problem description"
When you make a manual backup of system management, you are prompted to "fail to open Backup device" E:\ automatic backup \ufidau8xtmp\ufdata. BAK '. An error occurred on the device or the device is offline. For more information, see the SQL Server error log. -2147217900 "
Then click "OK" will prompt a suggestion "1, check the hint path of the disk remaining space size, or the hint directory exists; 2, check the system library account set path D:\u8soft\Admin\server\, and MDF data file directory (zt+ account set number, the reign of the years, This section is not guaranteed to be consistent in the system library.

"Cause of the problem"
Backup Temp directory cannot write "Unable to open backup device" E:\ automatic backup \ufidau8xtmp\ufdata. BAK ', should be without permission.

"Solution"
After you stop the U8taskservice service, you can delete the directory
Please make sure that the data should be backed up before the "precautions" are modified.
"Prompt" If there is a problem, please contact the timely mail

Solutions for cloud-dwelling communities:

SQL Server is run by a low-power user, and the Bak file is offsite, so the running user of the backup directory, SQL Server, does not have Read permission, so copy the Bak file to the location where the running user of SQL Server has read access. As long as you can select to this bak file, and then right to add everyone has Read permissions, and then restore the database OK

But maybe this database of SQL Server is running and needs to be set as follows

Using SQL statements, disconnect all user links and roll back all transactions, with the following specific SQL statements:

Copy Code code as follows:

ALTER database [DB name]
SET OFFLINE with ROLLBACK IMMEDIATE