Thanks Stephen, i have done all that and i have uploaded a cleaned backup database and opened ticket to restore.
the problem is that i am not able to bring the site to live till i have about 500 pages fixed , which is not an option.
just for work around , i have created a new database user with...