Elaine,

Try creating the empty test database first then use the production database
backup file to restore to newly created database to avoid conflict with
database file names. Otherwise, you will to restore with WITH MOVE option
as suggested.

Hope this helps.

Sang Nahm

-----Original Message-----
From: Fang, Elaine [mailto:Elaine.[Email Address Removed] Monday, October 28, 2002 10:33 AM
To: LazyDBA.com Discussion
Subject: sql 7 restore error -- help needed!


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









---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page