SQLTeam.com | Weblogs | Forums

SQL DB restoring Issue...need help


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 ...