Comments
Sort by recent activity
My laptop has 32GB of RAM. [image] If you have more 'active' data than the maximum memory limit of your version of SQL Server and your server doesn't have 20GB+ MORE than that limit, then you don't have enough RAM. Having said that, with clones you need some serious low-latency-high-throughput networking for it to be successful if the image files are not local. Does your server have a single 1Gb network card by any chance? Oh, and the storage that the images are on needs to be fast as well. Also, what is your server's storage comprised of? / comments
My laptop has 32GB of RAM. If you have more 'active' data than the maximum memory limit of your version of SQL Server and your server doesn't have 20GB+ MORE than that limit, then you don't have ...
The obvious question is have you verified that the production database is in fact not corrupted? Did you try recreating the clone? Do you get the same error if you do the same operation from a different client? / comments
The obvious question is have you verified that the production database is in fact not corrupted? Did you try recreating the clone? Do you get the same error if you do the same operation from a diff...
OK. Lets take a different tack then: Is there a way to use SQL Prompt such that you just see differences for objects/object types selected - without concern for anything else? I presume not, but it would be helpful in my current use case (finding differences between numerous supposedly-identical databases).
Regarding decrypt objects helping with performance, that should only make a difference if there actually are lots of encrypted objects, right? / comments
OK. Lets take a different tack then: Is there a way to use SQL Prompt such that you just see differences for objects/object types selected - without concern for anything else? I presume not, but it...