cant restore database from .a .bak file in enterprise manager

Hi Everybody,

I use MS SQL server 2000 enterprise manager on a windows server 2003.

I created a new database in enterprise manager, and try to restore the new database from a .bak file.
I went to -->restore database. I checked"from device"and select the right path to the .bak file.
Then I click ok, but there is anerrorpop up."tend to override existing database",
so I went to -->option, and checked"force override existing database". then I click ok, but get an error look like this http://ewwa.lo7.net/error.JPG

I thought it was a problem with my .bak file. So I try to use another .bak file which I am sure it is 100% good. It prompt the restore issucessfully. But when I checked the db, therenothing there(No tables).

I think there must be something wrong with my enterprise manager's configuration.

Do you know what happen with my enterprise manager? Thank you a lot in advance:)!!

barbarallama:

Hi Everybody,

I use MS SQL server 2000 enterprise manager on a windows server 2003.

I created a new database in enterprise manager, and try to restore the new database from a .bak file.
I went to -->restore database. I checked"from device"and select the right path to the .bak file.
Then I click ok, but there is anerrorpop up."tend to override existing database",
so I went to -->option, and checked"force override existing database". then I click ok, but get an error look like this http://ewwa.lo7.net/error.JPG

You tried to create a new database by restoring from a .bak file, right? Then there are some tips you may know:

1. Specify a database name that differs from existing databases for the new database, then the restore will create a new database rather than attemping to override existing database.

2. In the Options tab, make sure all values in the 'Move to physical file name' column point to a valid file path. If any path dose not exist, an error likeshttp://ewwa.lo7.net/error.JPG will be raised.

barbarallama:

I thought it was a problem with my .bak file. So I try to use another .bak file which I am sure it is 100% good. It prompt the restore issucessfully. But when I checked the db, therenothing there(No tables).

Not sure why this happened. Can you perform queries on the database? If yes, login as 'sa' and perform a query like this :

select * from sysobjects where xtype <>'S'

|||Hi Lori,
That is really helpful, the problem is the path is invalid. Thanks A Lot!