Friday, April 11, 2008

Restoring the CRM database

I’m a developer, not a DBA (even though my employer seems to think I should do both). So when it comes to something outside the realm of writing queries, creating tables, etc., I sometimes have to fumble my way through it. For example, I recently needed to do a point in time restore on our CRM database. I kept getting an error message about not being able to perform the task because the database was in use. This was on our dev version of CRM that I knew no one was using. Finally, I figured out that the IIS service (or just the related app pools) needed to be stopped on the CRM server because it was hitting the database.

Doh!

No comments: