| Author |
INCLUDE CHECKSUM IN OPERATION "BACKUP DIRECTORY"
|
|
| ASCRUS 2006-02-03, 7:23 am |
| SGkgYWxsLg0KDQpTaXR1
YXRpb246IC0gdGhlcmUg
aXMgYSBkYXRhYmFzZSB3
aXRoIHRoZSBwYXJh
bWV0ZXIgb2YgImNoZWNr
c3VtID0gZW5hYmxlIi4g
SWYgdGhlIGZpbGUgb2Yg
ZGF0YWJhc2UgaXMg
Y29ycnVwdGVkIChpbmNv
cnJlY3QgY2hlY2sgc3Vt
KSwgdGhlbiBjb25uZWN0
aW9ucyBkaXNjb25u
ZWN0IHdpdGggdGhpcyBl
cnJvciBtZXNzYWdlLiBJ
dCBpcyBjb3JyZWN0LiBC
dXQgdGhlIG9wZXJh
dG9yIG9mICJCQUNLVVAg
REFUQUJBU0UgRElSRUNU
T1JZIiBzdWNjZXNzZnVs
bHkgY3JlYXRlcyBi
YWNrdXAgZm9yIHRoaXMg
ZGF0YWJhc2UuIEl0IGlz
IG5vdCBjb3JyZWN0IC0g
YXMgYSByZXN1bHQg
YmVjb21lcyBpbXBvc3Np
YmxlIHRvIHJlY292ZXIg
YSB0aGlzIGRhdGFiYXNl
Lg0KDQpUaGFua3Mg
OikNCg==
| |
| Dmitri 2006-02-03, 7:23 am |
| ASCRUS wrote:
> Situation: - there is a database with the parameter of "checksum = enable". If the file of database is corrupted (incorrect check sum), then connections disconnect with this error message. It is correct. But the operator of "BACKUP DATABASE DIRECTORY" s
uccessfully creates backup for this database. It is not correct - as a result becomes impossible to recover a this database.
+1 vote :).
Dmitri.
| |
| Rob Waywell 2006-02-03, 1:23 pm |
| Please submit the reproducible case - including the corrupt database file
needed to reproduce it - to Tech Support. This will be the most direct way
to address the BACKUP DATABASE behaviour.
In the meantime, you do need to review and correct your backup and recovery
process to ensure that you *never* overwrite your last good backup. Two
significant steps that would appear to be missing in your current process
are:
1) Validating the database.
2) Rotating the backups
Another step that is perhaps less obvious is the importance of validating
your full backup of the database and log file in conjuction with moving a
copy of it to a secure offsite storage location.
--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional
Sybase's iAnywhere Solutions
Please respond ONLY to newsgroup
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
"ASCRUS" <ascrus@mail.tascom.ru> wrote in message
news:43e333e7$1@foru
ms-1-dub...
> Hi all.
>
> Situation: - there is a database with the parameter of "checksum =
> enable". If the file of database is corrupted (incorrect check sum), then
> connections disconnect with this error message. It is correct. But the
> operator of "BACKUP DATABASE DIRECTORY" successfully creates backup for
> this database. It is not correct - as a result becomes impossible to
> recover a this database.
>
> Thanks :)
>
|
|
|
|