on 2012 Mar 21 3:37 AM
Database version : 7 (yes, seven) The database consists of three files : database.db, database.log and one dbspace named sales_ct.db. The database size is about 200GB. The error code is WB002 (SQLE_BACKUP_NOT_STARTED). The users who may perform the backup have dba permissions. This means that the database "thinks" that there is a backup still in progress. Any kind of backup failed: a) client side following the dbtools approach b) server side using a custom backup event c) server side using the related procs.
The problem may caused by the missing but empty (unused) dbspace file which the customer forgot to copy at server removal.
So there are two questions: 1. How can I reset the "backup state"? 2. How can I remove and add again the missing dbspace file?
Request clarification before answering.
May the following FAQ be of help?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry for late reply. Seems to work but I'm not really sure about it at all: I unload data as described skipping both tables in the missing dbspace. The log shows both tables (with zero size). This has irritated me. I thought that they will be skipped completely - so that they are not mentioned in the log. Regardless of that no error occured. After that I reload the data into a new database. Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
30 | |
8 | |
8 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.