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...
First thing is to research your RDP tool to see if you can adjust screen size. Failing that, the next best idea is to get a better RDP tool. :-)
However, for a window that is not maximized you can click the upper left corner of the window and select Move from the drop down menu. So check to see if there is a keystroke combo that will get you that menu so you can get Move selected (with down-arrow and enter) and then you can use down-arrow to reposition the window. / comments
First thing is to research your RDP tool to see if you can adjust screen size. Failing that, the next best idea is to get a better RDP tool. :-)
However, for a window that is not maximized you can ...
Plus a bunch to this request. / comments
Plus a bunch to this request.
I'm not sure what the OP is asking for, or did, either. Offline as in detach the database? / comments
I'm not sure what the OP is asking for, or did, either. Offline as in detach the database?