I'm trying to restore a live db to a test db, but I keep getting a '..failed because the resulting cumulative db size would exceed...limit of 10240' error, yet my database is under 10GB, I feel like the answer is in the 'cumulative db size' part.
Being new to SQL Server, I find it confusing that different numbers are reported depending on where you look. I've done multiple purges yet the upper 10,243MB number doesn't seem to change. The source .BAK file size in bytes is: 10,622,637,056 (9.9GB) Also, autogrowth set to 50MB - could that allocation be pushing it over the limit? Since the source is the live db, I'm hesitant to monkey with the autogrowth limit. Suggestions appreciated!