Post reply

It seems our sql database is corrupted

  • July 14, 2014 at 6:05 am

    #151363

    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?

  • July 14, 2014 at 6:27 am

    #1729113

    Have you done a DBCC CHECKDB?

  • July 14, 2014 at 7:33 am

    #1729130

    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, MVP, M.Sc (Comp Sci)
    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

  • July 14, 2014 at 3:49 pm

    #1729294

    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, MVP, M.Sc (Comp Sci)
    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

  • July 15, 2014 at 12:54 pm

    #1729597

    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.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • July 16, 2014 at 12:35 am

    This was removed by the editor as SPAM

  • December 3, 2014 at 7:25 am

    #1762378

    Hi! Try to find something to fix this problem here:

    http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/569-i-have-a-problem-how-do-i-fix-a-corrupted-database-file

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply