Post reply

Restore Database

  • September 19, 2007 at 11:05 am

    #198028

     

    Now I've really screwed things up.  I tried to restore the database and received an error, "File already exists".  Now the database is gone and I can't get it back, I always get the same message.

    I tried creating a new db with the same name and restoring over the top of that, exactly the same results.

    What file already exists?

    How do I restore the database?

  • September 20, 2007 at 7:14 am

    #734914

    Can you post the error message and the steps you took to restore the db?

  • September 20, 2007 at 7:20 am

    #734919

    In Analysis Manager I chose the server and then Restore Database.  Selected the backup and the process ran. There were 102 files to restore and after 102, I get the error message, "File Already Exists".  My problem is that nothing tells me what file.

  • September 20, 2007 at 10:48 am

    #735010

    Delete all files in the data folder corresponding to this database, then try to restore the backup again.

  • September 20, 2007 at 10:48 am

    #735009

    Try restoring it to another machine, just in case there's an issue on that server. Then, if successful, make sure you dump the definitions and do a clean build.

    NB. Recommend you seriously look at moving up to SQL 2005, once you're past the emergency.

  • September 20, 2007 at 10:53 am

    #735013

    I tried deleting all of the files; no joy.

    I wish I could move to 2005, but that won't happen.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply