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
Comments