Unanswered: Error restoring db under a different name!!!!
I'm trying to restore a db under a different name (for UAT purposes). Every time I try this I get an warning message. The title of this message is "Microsoft SQL-DMO (ODBC SQLState: 08004)" and the rest of the error message goes as such:
"Could not locate entry in sysdatabases for database 'UATDB'. No entry found with that name. Make sure that the name is entered correctly. Backup or restore operation terminating abnormally"
I'm trying to restore from a Complete backup with diferential backups when the error crops up. To get around this I have to perform a complete backup, and then restore as soon as this backup has completed. The error doesn't happen if done this way.
Has anyone had a similar problem or know a way of getting around this???