Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Location
    Copenhagen, Denmark
    Posts
    2

    Question Unanswered: Problem restoring a database

    Can any of you give me a hint why we have problems with restoring a database. The database is 300 GB, divided on 4 database files in the primary filegroup and running in simple recovery mode. The restore starts and finish after few minutes saying 'Restore completed successful' but the database is in Loading mode.
    Ergo, the restore is not successful. The only way we can restore the database is to drop the database and delete the files and create the database via the restore. But then it creates 4 data.MDF files and not 1 MDF and 3 NDF files and the name on the files are not the same as the original. Why?

    We are running on a SQL 2000 SP4 but the backup was taken under SP3A

    Regards Anna-Lena

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What does

    RESTORE VERIFYONLY

    This tell you...I'm thinking something not to nice...

    That should be part of your back up procedures.....And at 400 GB....that's a lot of data...I would also have a standby box to test the dump and restore immediatley after....how long does 400 GB take to dump?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •