| Event Id | 3201 |
| Source | MSSQLServer |
| Description | Cannot open backup device %ls. Device error or device off-line. See the SQL Server error log for more details. |
| Event Information | CAUSE: One or more of the files specified in a BACKUP or RESTORE command could not be opened. The potential reasons for this include: 1. The path specified does not exist. 2. The path or media specified is currently unavailable. 3. The account performing the operation does not have sufficient permissions to read from and/or write to the specified file(s). 4. A mapped drive has been specified and is not available to the service or account executing the command. RESOLUTION: 1. Review the SQL Server error logs and the Event Viewer logs for other errors around the same timeframe. 2. Verify that the server on which the disk or tape drive resides is running and is accessible from the machine where the SQL Server instance is installed. 3. Run diagnostic checks on your hardware to verify that the disk or tape drive is still operating correctly. 4. Ensure that the account issuing the command has full control of the files specified in the command. If the command was executed from a scheduled job then the startup account for the SQL Server Agent must have full control of the files specified in the command. 5. If the file is on a tape, verify that the correct tape is in the tape drive. 6. If the file previously existed, verify that no other program has the file open. 7. If you specified a mapped drive in the command or the backup device definition, rewrite it to use a URL instead. |
| Reference Links | Microsoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 3201 |
Catch threats immediately
We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.