Buy xenical drug online

Today I learned the hard way that your data isn’t always safe.

I created an buy xenical drug online Admin interface for one of my clients that basically manages an buy xenical drug online Image Gallery. The gallery allows for a Category and SubCategory structure.

I received a buy xenical drug online call at about 10:30am asking where all of his images were?  After doing some investigating, my heart stopped, I found the bug.

I had a bug in my SubCategory_Delete proc that didn’t have the WHERE SubCategoryId = @SubCategoryId clause. When a buy xenical drug online user would delete a SubCategory it would delete all the buy xenical drug online photos in the image gallery instead of just the photos in that buy xenical drug online specific SubCategory.

My initial thought was to get the backup.  Well it turns out backups aren’t created automatically.  This is something you need to manual do when creating a database.

I was fortunate enough to buy xenical drug online have a great Customer Service rep, Sean Fox, that somehow managed to buy xenical drug online convince MOSSO’s IT team to buy xenical drug online create a backup for me from their disaster recovery backups.  Thanks MOSSO.

So after first going to buy xenical drug online my client with my tail between my legs I was able to buy xenical drug online go back to him as a hero. “Your data has been saved!”

I’ve since put in place a buy xenical drug online backup plan for all of my databases hosted at MOSSO.  I found this article in their Knowledge Base: http://help.mosso.com/article.php?id=34 buy clavamox mexico6 for MSSql. There is one for MySql, http://help.mosso.com/article.php?id=356.

I modified it buy xenical drug online a bit by creating a console app that is scheduled nightly and buy xenical drug online ran on my server.  This way only I can execute the backup.

My advice is to put this in place before you need it, not afterwards.

Filed under: Web Development   Tags: Best Practices, Hosting, MSSQL cheap cialis daily, Rackspace Cloud,
 No Comments »