Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2003-04-25 : 04:58:26
|
| Hello ,I am trying to restore a 2 GB database from a backup file on a SQL 2000 server . After 70 % ( I think ) of the restore it pops up an error message that data is inconsistent . I checked the event viewer and the error says that :The backup data in 'E:\Restore\backup\CUSTOMERS_bk' is incorrectly formatted. Backups cannot be appended, but existing backup sets may still be usable.And then in the enterprise manager i see that the database CUSTOMERS is shown in a loading state . How do i remove the database as it has to be removed from the system catalogs . How "s that possible ?Is there any other solution for this ? I checked the space on the drive and is 20 GB . Tksadmin001. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-25 : 12:33:19
|
| Have you tried deleting the database from Enterprise Manager? How about running DROP DATABASE DBName (where DBName is the name of the database) in Query Analyzer? How about sp_detach_db in Query Analyzer? Please see BOL for the syntax. But you should be able to just click on the database in Enterprise Manager and hit delete.The problem that you are having is with the backup file and not with the restore (most likely at least). I would rerun the backup and try again.Tara |
 |
|
|
|
|
|
Database in Loading state.