Failed to backup “firstdb” database with “Full” backup type: One or more errors occurred. > Cannot open backup device ‘c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS2008\MSSQL\Backup\firstdb202008232246.bak’. Operating system error 31(A device attached to the system is not functioning.).
BACKUP DATABASE is terminating abnormally.
Anyone can help me with this ?
Hello Sai_Sriram,
It seems you try to connect to your remote SQL Server using Microsoft SQL Server (local) Server type. Please install SQLBackupAndFTP on the same server where SQL Server is installed or use Microsoft SQL Server (remote) Server type.
Please find more details at https://sqlbackupandftp.com/blog/remote-sql-server-backups-explained
If you have any other questions, please let us know.