Andy,

What will happen if you just drop this test? Is there any chance the problem you are testing will go unnoticed?

I don't think so. If your database is gone, every other test will surely fail as well, right?

So let us apply Occum's razor and remove this test - it does not add any value. The biggest problem with unit testing T-SQL is slowness, so getting rid of unnecessary tests is highly important.

Thanks.