Server backup crashes site

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
milstencil
Ensign (ENS)
Ensign (ENS)
Posts: 15
Joined: Sun Jan 11, 2009 10:48 am

Server backup crashes site

Post by milstencil » Fri Apr 03, 2009 5:51 am

Site has been running fine, and I mean really great, for the first week of its life. Thursday morning when
server backed up, the site crashed. They were able to get back online by rebooting the data base.
Last night the same problem. I would appreciate any help.
Error message below.
Thanks,
Rick

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: Server backup crashes site

Post by AbleMods » Fri Apr 03, 2009 6:02 am

Either they're shutting down SQL services on the SQL server during backup (big no-no) or their SQL server lags during the backup causing logins to timeout.

It would have to be a pretty weak SQL server to lag so bad during backup that it cannot authenticate a SQL login from the site. Or they've got the priority on the backup jacked up so high that the server won't let anything else happen until it's done.

My guess is their backup procedure involves stopping SQL server services so their backup software doesn't throw any open-file errors. Easy mistake to make if you're not fluent with SQL server management and deployment.

Either way, the problem is on their server and has nothing to do with your website software. AC7 runs just fine when using standard SQL backup practices on adequate equipment.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

Post Reply