BUG: Scripting from large SQB Bombs

PDinCA

362 GB SQB, using 12.1.0.3760, licensed, on Win 2012R2

Need to script schema and procs to file folder.

Process ran for over an hour, then bombed-out with some error about "Quotas", which was reported-back to Red Gate.

We don't have a SQL 2016 any longer that can hold the restored 1.5 TB DB, minimum. We want to regain the 362 GB that the now-unwanted backup is consuming.

SQL Compare needs fixing. Maybe a 64-bit version might not have quota issues, who knows.

It's broken and unusable, aside from which, after reporting the crash to Red Gate, the UI froze completely and had to be killed via task manager.

Andrew P

Hey PDinCA,

Thanks for contacting us and sorry you are having this issue!
SQL Compare is a 64 bit program, but it potentially had some issues reading such a large backup.
How much free space did you have on your local machine when you ran this?
Did you notice a memory/HD usage spike during use?
Would you mind enabling logging and sending in the log file? https://documentation.red-gate.com/disp ... +log+files

Thanks!

PDinCA

Verbose/Warning/Error?

C: drive has 250GB

Wasn't watching memory or HD at the time, sorry...

PDinCA

Downloaded 12.1.4.3873 and commenced compare with verbose logging.