Create Image error

azizkarim

I am using a backup file without password to create a new Image. Backup created in SQL 2014. Creating image using SQL 2016 instance. At the end of the process I see error message "sql clone user does not have permission to alter database 'SqlCloneTemp_editg01 database does not exists or not in a state that aloows access checks ALTER Database failed"

azizkarim

I think I know it now. Backup file path ca not be unc path

ChrisHurley

Hi, hopefully you've resolved your problem, but this is a problem that we see if the login being used by the SQL Clone Agent doesn't have sysadmin privileges when creating images from backup.

The backup path needs to be one which can be restored by the instance of SQL Server that you're using. UNC paths should work, but note that the account being used to access the backup is the account that the SQL Server service is running as in this case, not e.g. the SQL Clone Agent service's account.