page not found after restoring from the backup except home page (Tried all solutions, which I got through googling)?
Looks like you have lost your .htaccess in the process. Download newest Drupal core from Drupal.org, extract it and put .htaccess in the root directoy of your Drupal. If this still does not work, and your .htaccess is ignored, go to official Clean URLs documentation, and find a section Server configuration for Clean URLs on a dedicated server, with httpd.conf - this should show you how to configure it properly.