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_member262203]

Thanks Mandeep...but my doubt is still not resolved...how could a bckup size of DB reduced suddenly...dbcc is the way to check consistency ...okay..if i execute it again it gonna take a load of time....isnt there nay other way to check DB consistency in better way and could find what happened exactly....

Thanx in advance

[Former Member]

Hi Sharad,

I believe you're over working on this.

As far as I know we cannot control over Backup image size, it will be what it can be depending on what all is backup and what DB size is.

Anyway, you can work towards compressing the backup image and other things..

1750510 - FAQ: Sybase ASE 15.7 Compression

2226574 - Too many dump files are created after backup in IQ.

Regards,

Prithviraj.