Follow Up: Access to table dbo.Versions is blocked because the signature is not valid

This is really just a follow up to a post a wrote a while back and more of a reminder for myself. If you do a lot of backup/restore operations of content databases from production to development environments, you’ve no doubt run into the infamous:

Msg 33002, Level 16, State 1, Line 1
Access to table dbo.Versions is blocked because the signature is not valid.

I hate this particular error because it’s a little deceiving sometimes. In the past, I’ve attributed this error to differences in the patch level between your production and development environments. You can read all about it here.

But sometimes, when I do my standard backup/restore from my production server to my development server, I still encounter this error, even though my patch levels are the same. No amount of IISRESETS, SQL Service resets or WSS service resets makes any difference. What I find myself having to do is run the following command:

psconfig –cmd upgrade –inplace b2b -wait

After running the above, everything is all happy again. I needed to make a note of this more for myself because I can never remember what the command parameters are when I need it.

No comments yet.

Leave a Reply