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
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?