Microsoft SQL-DMO (ODBC sQLstate:42000)
kindly help me. thanks
Please check the Agent job permissions for the user to access the folder. To know more please go this one it may be helpful to you. http://sqltechtips.blogspot.in/2016/01/database-terminating-abnormally.html
Looks like you need to specify a valid Destination location for the database. RESTORE is probably trying to use the SOURCE location, stored in the backup file, as the Target - and probably that folder doesn't exist. Either way, "C:\Program Files..." is a lousy location to store data ...