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.
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!
