Hi list,

I successfully did a complete back up a prod database (3GB) and now trying to restore it to the same server under a different name for test purpose. (I know it's better to put prod and test db on different servers, but that's what they have now :))

However, when I tried to restore from the back up, I got the following error msg:
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Microsfot SQL-DMO (ODBC SQLState: 42000)

Encountered an unexpected error while checking the sector size for the file 'e:\mssql\data\OnyxTest.mdf'. check the SQL Server error log for more information.
Could not create one of more files. Consider using the WITH MOVE option to identity valid lcoations.
Backup or restore operation terminationg abnormally.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Any idea what might went wrong? FYI -- this is a SQL 7 database.

A side question: How to check the restore model used by a sql 7 db?

Thanks,
Elaine








MS Sql Server LazyDBA home page