Database consistency check

[#1]

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]

i used DBBC checkdb command ...but unfortunately i had to stop it in middle...due to time consumption .
could it make any impact.

[Former Member]

Hello Sharad Kumar:

Cancelling DBCC check should not impact your DB consistency.  While executing your DB checks you have to be patient as it is a time consuming process as everyone here has already mentioned.

thanks.