Fix SQL Server ‘Insufficient Access Rights’ During Backup

Last updated: August 26, 2026.

A SQL Server backup can fail because the login lacks database backup permission or because the SQL Server service account cannot write to the destination folder. These are separate permission checks.

Check database permissions

USE ApplicationDatabase;
GO
ALTER ROLE db_backupoperator ADD MEMBER [backup_login];
GO

Members of sysadmin, db_owner, and db_backupoperator normally have backup permission. Grant the narrowest role appropriate for the job.

Back up to a server path

BACKUP DATABASE [ApplicationDatabase]
TO DISK = N'D:\SQLBackups\ApplicationDatabase.bak'
WITH CHECKSUM, COMPRESSION, STATS = 10;

The path is evaluated on the SQL Server host, not the computer running Management Studio. Grant the SQL Server service account write access to the folder, then verify the backup with RESTORE VERIFYONLY. See Microsoft’s SQL Server backup permissions.