Options

Create Image error

azizkarimazizkarim Posts: 6 New member
in SQL Clone
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"
Tagged:
· Share on Twitter

Answers

  • Options
    azizkarimazizkarim Posts: 6 New member
    I think I know it now. Backup file path ca not be unc path
    · Share on Twitter
  • Options
    ChrisHurleyChrisHurley Posts: 54 Silver 2
    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.
    · Share on Twitter
Sign In or Register to comment.