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]

agreed ..obviously back-up size depends on DB size ...thats why i am scared ...what happened to DB so its .dmp file reduced to its size by almost upto 3 GB..and its compressed...so in case of data loss think how much data we ve lost..

although more than 3 weeks have been passed ...restored it on TEST ...didnt get any complaint from Functional guys or from users..what I have done is only incomplete DBCC ....so i want o clear my doubt of data loss

[Former Member]

Hi Sharad,

3GB data loss... what made you think that data is lost here? Just because the backup size has reduced to a size does not (or will never mean) there is data loss.

If backup is running with same set of tables/tablespace (or entire database) and is completing successfully, you need not worry about size.

Regards,

Prithviraj