Create certificate from backup fails on SQL Server 2008

This is so going to bite yer ass if you don't pay attention… As usual, a very quick post: I tried to create (ok, restore) a certificate from the production server to our DR server, so that the automated restores would work. When I ran the script (yes, CREATE CERTIFICATE … FROM FILE […]), I … Continue reading Create certificate from backup fails on SQL Server 2008

Error message: “A database snapshot cannot be created because it failed to start” when running DBCC

I recently learned to hate even more the virtualization thing – once your host fails, guess what, everything else goes downJ. Anyway, the topic for today is not related to my personal feelings, but to DBCC failing on one of my servers. Msg 1823, Level 16, State 2, Line 1A database snapshot cannot be created … Continue reading Error message: “A database snapshot cannot be created because it failed to start” when running DBCC