DB Restore problem
Hello all,
I've been reading this threadhttp://forums.microsoft.com/msdn/ShowPost.aspx?postid=1494867&siteid=1 because I've been having a similar problem.
I wanted to post a new thread to make sure that people have an opportunity to see it and, hopefully, give me some help.
I have a backup of my production database and want to restore it over my development database (using Enterprise Manager). When I first tried the restoration it worked but the application (Siebel) using the database wouldn't log in. Stupidly, instead of reading the log files for the application I panicked and restored the dev database with an old copy of the dev database. Unfortunately this backup was either not complete or had some other problem because that restore failed.
I then tried running the restore (again from Enterprise Manager) of the dev database with my production backup and began receiving the MOVE FILE error discussed in the abovementioned thread.
So, following the instructions in that thread, I attempted to run the RESTORE FILELISTONLY command from SQL Query analyzer and get this message:
"Could not locate entry in sysdatabases for database 'siebel_prod.' No entry found with that name. Make sure the name is entered correctly."
