Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

It seems our sql database is corrupted Expand / Collapse
Author
Message
Posted Monday, July 14, 2014 6:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 14, 2014 6:04 AM
Points: 1, Visits: 0
Hi,

is there a way to completely check a SQL-Anywhere database (5.5.05)
integrity?

"Validate" won't help: we had databases that were broken but "validate"
always told us that everything is o.k. :-(

I had the idea to simple read every record in every table (first "select
count(*) from...", second "select * from ...") Number of readed records must
be same as the number of records reported by the "count(*)".
- This works ok (i can report errors) - but I have found a database that
will "hang" on the "Count(*)" (seems to loop forever, CPU-Usage 100% for
>20Min (than i stopped it)

Any other ideas?
Post #1592152
Posted Monday, July 14, 2014 6:27 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 10:09 AM
Points: 508, Visits: 1,877
Have you done a DBCC CHECKDB?

Post #1592155
Posted Monday, July 14, 2014 7:33 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 10:07 AM
Points: 40,404, Visits: 36,848
This site is for Microsoft SQL Server. As such, we can't necessarily help with problems on non-SQL Server platforms. You'll probably get better help if you find forums specifically for Sybase SQL Anywhere.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1592176
Posted Monday, July 14, 2014 3:49 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 10:07 AM
Points: 40,404, Visits: 36,848
georgeleonard70 (7/14/2014)
i used

EXEC sp_resetstatus D0011112;

ALTER DATABASE D0011112 SET EMERGENCY

DBCC checkdb(D0011112)

ALTER DATABASE D0011112 SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB (D0011112, REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE D0011112 SET MULTI_USER

D0011112 is Suspected Database name


No, no, no! Horrible advice, even without the fact that the OP doesn't even have a SQL Server database.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1592368
Posted Tuesday, July 15, 2014 12:54 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 7:46 PM
Points: 3,220, Visits: 2,361
SQL Anywhere v5... is probably more than 15 years old.

Also, SQL Anywhere is a Sybase product.

Good luck with it - just remember google is your friend (there are still lots of references for this antiquated software out there. I even had one that old to deal with a few years ago so I feel your pain.




Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #1592760
Posted Wednesday, July 16, 2014 12:35 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, November 6, 2014 8:19 PM
Points: 121, Visits: 1,251
Try to unload & reload the database.

You can find detailed information about Validation utility at
http://dcx.sybase.com/1201/en/dbadmin/dbvalid.html

To get more help, you can try SQL Anywhere dedicated forum:
http://sqlanywhere-forum.sap.com/


SQL Database Recovery Expert
Post #1592922
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse