Database consistency check

[former_member262203]

Dear experts,

My Env is- Aix+Sybase. Backup device is tape. i need to take back-up daily so there is scheduler is set for the same.take backup of transactions hourly.

now issue is that  previously the size of my back-up .dmp(PRD sys) file was approx 55GB but all of sudden it reduced to 52 gb from last five days so i was scared if there would any data-loss..for that i just restored it on Test server and run dbcc checkdb.it took too much time i had to hault that after 6 hrs.
Both system is functioning properly no compalints from user and functional consultanats till date.

is there anyway to check DB intergrity..easily
Pl help

[Former Member · Accepted solution]

Hi Sharad,

I have zero knowledge on SYBASE database, but than why are you performing consistency check?

Consistency operation is only when you perform refresh activity or you find any database corruption.

and yes this operation is time consuming and consumes lot of resources.

Backup image size with mostly depend upon your database size, for any live system we have insert/update/delete operations performed on database this increases/decreases database size which in return will have effect on your backup image size.

Regards,

Prithviraj.