SQLTeam.com | Weblogs | Forums

SQL DB restoring Issue...need help


#1

Microsoft SQL-DMO (ODBC sQLstate:42000)

kindly help me. thanks


#2

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


#3

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