01 Jun 2010
05 Oct 2012
Link to this post
I have always had multiple sites per App Pool and at the urging of Telerik Support today I began to give each site it's own App Pool with 512mb of memory allocated to it. Out of 12 sites, all but one started correctly. When trying to start the final site my it timed out three times and finally told me 'Incorrect Syntax near -'. My Database does have a dash in it, so I renamed the database from SF-SiteName to SFSiteName. No help.
My database went into recovery mode. Twenty minutes later I could examine the tables but opening up each tree node in SQL Server trying to get to the tables took 10 minutes. I deleted the database and tried to restore from last night. After 10 minutes the restore was complete (this usually takes 10 seconds). The same problem was present with an extremely slow database, even though I index nightly. I finally restored to last Friday and my site is stable again.
I am missing a weeks worth of data now and have no clue why this happened. Has anyone ran into anything similar?