Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about the solution that when sqlserver restores the database, it is prompted that the backup device cannot be opened. Many people may not know much about it. In order to make you understand better, the editor summarized the following content for you. I hope you can get something according to this article.

[problem description] when the system administration performs a manual backup, there is a prompt "unable to open backup device'E:\ automatic backup\ ufidau8xTmp\ UFDATA.BAK'. The device has an error or the device is offline. For more information, please refer to the SQL Server error log.-2147217900" click "OK" to prompt a suggestion

1. Check the size of the remaining disk space in the prompt path, or whether the prompted directory exists

2. Check whether the prompted system library accounting path d:\ u8soft\ Admin\ server\ is consistent with the mdf data file directory (ZT+ account number\ year number, which is not saved in the system library).

[cause of problem] backup temporary directory cannot be written to "unable to open backup device'E:\ automatic backup\ ufidau8xTmp\ UFDATA.BAK', should not have permission.

[solution] delete the directory after stopping the U8TASKSERVICE service [Note] be sure to back up the data before modification; [hint] if you have any questions, please contact us by email.

The editor's solution:

After checking that the sqlserver of the server is run by a low-privileged user, and the bak file is backed up remotely, so the running user of the backup directory sqlserver does not have read permission, so copy the bak file to the place where the running user of sqlserver has read permission, as long as you can select the bak file, then right-click to add everyone to have read permission, and then restore the database OK.

However, it is possible that the database of sqlserver is running and needs to be set up as follows

Use the SQL statement to break all user links and roll back all transactions, as shown in the SQL statement:

The code is as follows:

ALTER DATABASE [database name] SET OFFLINE WITH ROLLBACK IMMEDIATE

After reading the above, do you have any further understanding of the solution when sqlserver restores the database and indicates that the backup device cannot be opened? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.