Forgot to add parenthesis around an OR (was a bunch of ANDs previously) and screwed up data in a 200+ GB database... Time to delete it and restore another one from a backup that's on a network drive.... *sigh*

All the best buddy.

We crate snapshots of the test vms before testing. Takes just seconds to restore and you are where you left

@Kimmax I don't have access to the host for the virtual machine that holds my SQL server and the team in charge of those would kill me if I went to them every 5 minutes to create a snapshot and restore a snapshot :) but, seems like a great idea, might try to get them to adjust how we work to accommodate that, thanks :)

And of course, thank you @A-0-C

@Bikonja if you ask them, they can allow you create and delete a snapshot via script without needing extra access. That's what our hosting provider did for us. Not sure what exactly they did, I'm guessing it's user impersonation in the script somehow.

@ninjatini cool, I'll research that a bit, thanks!