Issue trying to restore data in production enviroment. Need Help!

Application issues
1

Failed to restore “55ALL1051” database on “Restoring” step. > Failed to run T-SQL command: GRANT CONNECT TO [epmtest] AS [dbo]

Cannot find the user ‘epmtest’, because it does not exist or you do not have permission.

I ran a backup job from a remote server, then tried to restore to a local server. Seems that somehwere between the backup and restore I nuked 4 of my customer databases. Tried to restore from the remote server and it failed with the error above. I have no idea and now have 4 customers totally down.

2

Hi Kory.
Remote backup creates a simple script that creates databases then inserts the data. For that particular error, create user epmtest yourself in SSMS.