My hosting company does have daily backup but I don't trust hosting companies anymore. I want to have the backup avaliable myself. I will ask them if there is any...

I have solved this problem. This was because the tables and the stored procedures were owned by the old user. I used the scripts explained on this page: http://weblogs.asp.net/owscott/archive/2004/01/30/65229.aspx and...