MSSQL restore fails


#1

Trying to restore from zip(sql files in it) file created with SQLBackupandFTP to a remote mssql server on shared hosting.
Restore fails with error "Job execution error: Kill database failed for Server ‘…net’. > Drop failed for Database ‘m3db’. > An exception occurred while executing a Transact-SQL statement or batch. > Cannot drop the database ‘m3db’, because it does not exist or you do not have permission. Computer name: “DESKTOP”
Probably there is lack of permissions, but database is already created with hosting panel, is there option not to drop it first?


#2

Hi Alexander_Nikiforov,

A database should be dropped first, and there is no way to ignore that step.

Could you please test, are you able to restore that backup via SQLBackupAndFTP?

Sorry for the inconvenience.