How can we help you today? How can we help you today?

BUG: Scripting from large SQB Bombs

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.
PDinCA
0

Comments

3 comments

Sort by
  • 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!
    Andrew P
    0
  • PDinCA
    Verbose/Warning/Error?

    C: drive has 250GB

    Wasn't watching memory or HD at the time, sorry...
    PDinCA
    0
  • PDinCA
    Downloaded 12.1.4.3873 and commenced compare with verbose logging.
    PDinCA
    0

Add comment

Please sign in to leave a comment.