error creating image from backup

eric99

Hello, 
I'm getting this error when creating an image from a backup file (bak or sqb): 

Database 'SqlCloneTemp_xxxxxxxxx' cannot be opened because it is offline. (SqlException)

The SqlCloneTemp database (but not the data files) gets created in the specified server with status= "offline".  

The sql error log entry states:

"FCB: Open failed: Could not open the file C:\Users\[clone svc acct]\AppData\Local\Temp\guid\dbname.mdf' for file number 1. OS error: 3(The system cannot find the path specified"

So... two questions: 
1. How can we fix this error, and
2. Can I specify a different location for where  the "SqlCloneTemp" db gets created rather than the temp directory?   

Thanks
Eric

owen.hall

Apologies for the delay on getting back to you on this!

Ordinarily the database files would be restored from backup directly into the image destination, so for them to appear in the temporary directory is unusual.

The best path forward here is probably to get in touch with our support team directly (support@red-gate.com) so that we can arrange to have a look at the agent log files and see what's been going on.

eric99

thanks Owen for the reply. After granting the service account sysadmin rights we were able to resolve the issue. 

owen.hall

Great, I'm glad you were able to get things sorted.