Error:

Msg 3203, Level 16, State 1, Line 7
Read on "H:\Backups\MyBackupFile.bak" failed: 1453(Insufficient quota to complete the requested service.)
Msg 3013, Level 16, State 1, Line 7
RESTORE DATABASE is terminating abnormally.

Fix 1:

Remove “maxtransfersize” from restore statement.

-- removed maxtransfersize = 4194302, buffercount = 96
RESTORE DATABASE AMS FROM DISK = 'D:\DBBackups\MyBackupFile.bak'
WITH FILE = 1, replace, stats = 5, maxtransfersize = 4194302, buffercount = 96,
   MOVE 'MyDB' TO 'D:\MSSQL\MyDB\Data\MyDB.mdf'

Fix 2:

Restrict the max server memory setting of the Sql server to allow other application to run properly.

SSMS -> SQL Server -> Properties -> Memory

Last modified: July 20, 2020

Author

Comments

Write a Reply or Comment