Suspect SQL Database - HELP Needed - repost

Budget $750 - $1500 USD
Bids 14
Average Bid $1648

OS: Windows Server 2003
SQL: MSSQL Server 2005

[url removed, login to view] file is 13,4 GB
[url removed, login to view] file is 1,7 GB

We saw that our database became to "suspect" mode after a power cut.

We executed this query;
EXEC sp_resetstatus 'dbName'
and this quert;
ALTER DATABASE dbName SET EMERGENCY ;
to set the database to emergeny mode.

At this stage, we stopped sql server and took manual backups of .mdf and .ldf files.

We started sql server again and performed a db check by executing this query; (results are at the attachment)
DBCC checkdb('dbNAme')

And we modified database to single-user mode from properties>options>restrict access.

Then we executed this command to repair the database;
DBCC CheckDB ('dbName', REPAIR_ALLOW_DATA_LOSS)

After 17 hours, we got error. Error message is at the attachment.

We need professional help for repairing / rescueing.

(PS: Our last regular DB backup was performed at June 2012)

Post a Project Like This

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • qualifiedcoders Profile Picture

    qualifiedcoders

    NEW DELHI,  India

    Qualifiedcoders is a company having 67 professionals working in various domains. Our company follows complete software development life-cycle and has been developing huge web based and desktop based applications. Established in Year :2007 Number of Employees : 67(as of january'2011). Business Domain: Banking,Manufacturing and Production,Wholesalers,Telecom,IT Offshore Outsourcing. Few of the websites developed in different domains are listed below: Note: To avoid search engines to crawl this page, we are placing '*' and '&' symbols in the urls so please remove tehm from the URL before you navigate to any of the link. Social Networking 1)www.i*a*m*an*art*ist.com 2)www.t*h*ed*i*s*k.com/index.aspx 3)www.t*e*c&h*n&o*u&s*a.com/phpdone/facebooklearn/ 4)www.c*a*b*o*d*e*n*t.org 5)www.s*p*a*r*t*a*c*u*s*p*2*p.com 6)www.a*c*tiv*chal*le*n*ge.com 7)www.t*e*c*h*n*o*u*s*a.com/ajhub/ 8)www.5*m*i*n*u*t*e*s*a*w*a*y.co.uk 9)www.t*e*c*h*n*o*u*s*a*.com/socialnetworking/ And many more: Auction websites Pay per click website such as Swoopo 1)www.r*unlive*au*cti*ons.com 2)www.j*or*gi*t.com 3)www.i*ama*na*rt*is*t.com/l*ive*auc*tions/index.aspx Lowest unique Bid Auction 1)www.t*e*c*h*n*o*u*s*a*.com/phpdone/lowestbidauction/ Matrimonial Websites : 1)Clone of www.s*h*a*adi.com www.t*e*c*h*n*o*u*s*a*.com/shaadi/ 2)Clone of www.j*ee*va*ns*a*a*t*hi.com www.t*e*c*h*n*o*u*s*a*.com/demo/jeevansathi/ Real Estate Websites 1)Clone of www.r*e*d*f*i*n.com with google maps www.t*e*c*h*n*o*u*s*a*.com/realestate/home.aspx 2)Clone of www.i*n*d*i*a*p*r*o*p*e*r*t*y.com www.t*e*c*h*n*o*u*s*a*.com/property/index.aspx 3)Clone of www.m*a*g*i*c*b*r*i*c*k*s.com www.t*e*c*h*n*o*u*s*a*.com/phpdone/magicbricks/

    PHP, Perl, ASP, and C Programming

  • weonlydo Profile Picture

    weonlydo

    Auckland,  New Zealand

    I am a freelancer domiciled in New Zealand. Don't let my time zone fool you though - I work around the clock and can adjust my schedule to work around your project. My core strengths are programming, APIs, scripts, macros, diagnostics, server administration, troubleshooting ... have I just covered all aspects of IT? I have been in the industry nearly two decades and have done all sorts of projects from front end through back end and the middleware in between. Check out my reviews and completion rate, then judge me for yourself when I complete your project. I apologize to the stones that WILL be turned to uncover the solution to your problems, none shall be spared!

    PHP, Perl, ASP, and Java

  • karthikv92 Profile Picture

    karthikv92

    Madurai,  India

    Extensive hands-on experience around 9 years, On Systems Administration, Windows Server Administration, Clustering, SAN Configuration, Remote Administration, IT Operations, Infrastructure implementation and support and Technical Support in SQL Database Administration, SQL Server Installation & Maintenance, Configuring Jobs & Trouble Shooting, Database clustering, Database optimization and Database Recovery. Hands-on experience in Desktop Administration, Installation, Troubleshooting and Support Gained Functional knowledge in Healthcare Domain administration, Strategy Implementation and Key person handling of any management aspect in and out of a Healthcare setup.

    Windows Desktop, System Admin, Data Entry, and Excel

  • tsbcrop Profile Picture

    tsbcrop

    Hyderabad,  India

    We are professional spftware development company with the following skills: AJAX, Java, J2EE, Mobile App expert

    ASP, Java, JSP, and Javascript

  • enmesh Profile Picture

    enmesh

    Bhopal,  India

    Set for Quality work.

    Java, .NET, Graphic Design, and Translation

  • absseo Profile Picture

    absseo

    Chennai,  India

    ABS is a premium Digital Marketing and IT development firm based in India. ABS is founded by people who have combined experience of more than 30 years in Digital Marketing and IT Development. Services offered IT Programming & Database Development We have a seasoned team of 10 programmers who are well learned and experienced in various programming languages like PHP, C# and .NET. Our team also consists of certified SQL Server experts and programmers. We do have experience ranging from developing web applications, Designing databases, Wordpress plugin configurations and Creating BI reports using OBIEE, Informatica and Cognos Our Expertize - Cloud: Amazon EC2, - Web Application: PHP/MySQL, - Database: PLSQL, MS SQL Server, MySQL, DB2 - Datawarehouse: Installation of Datawarehouse package in Windows & Redhat Linux - ETL: Informatica power center, SSIS, ODI and DAC. - Reporting: OBIEE, Cognos, SAP BO, Microstrategy, Qlikview and SSRS. Digital Marketing Our team of 10 digital marketers work with 100’s of client throughout the year. We have helped various small businesses and professionals ranking from Doctors, Lawyers, Plumbers, Salon’s, Moving companies, Florists and E-commerce portals to improve their presence online. Our strategy will make sure that your online business will becomes self sustainable and grow on it’s own. Our Expertize - White Hat SEO - SEM - Link Building - Social Media Marketing - Google Panda and Penguin Recovery - Google Analytics setup Virtual Assistance We have a small team of 5 virtual assistants who can assist you with Data collection, Data mining, E-mail sending, E-commerce website product upload, Social media posts scheduling and web research. Our virtual assistants are well experienced and we do have experience working with many small business and provide them affordable solutions with highest quality.

    Graphic Design, Internet Marketing, Data Processing, and SEO

  • nvenky2010 Profile Picture

    nvenky2010

    Bangalore,  India

    Part Time Worker

    Script Install, Copywriting, Data Processing, and Data Entry

  • techwelfare Profile Picture

    techwelfare

    kolkata,  India

    Techwelfare A complete website development firm that provides high quality services for the clients all over the world. We are a team of highly experienced professionals in different areas of computer science. We work based on four main principles: Quality - the highest quality of products is guaranteed including free support. Time line - we provide our services in strong time deadlines. Communication - we try to be always online and free for communications. Security - All the information/transactions is highly secured.

    PHP, Javascript, XML, and Script Install

  • Itdap Profile Picture

    Itdap

    Everglades,  United States

    We are ready to assist our clients whenever and wherever they need it. See how our team can help your business succeed.

    ASP, .NET, Windows Desktop, and System Admin

  • sirtacitllc Profile Picture

    sirtacitllc

    Tecumseh,  United States

    I have 10+ years of experience in software development for Microsoft platforms. I hold various certifications from Microsoft and CompTIA, and I have a strong knowledge of all aspects of Windows client/server enviroments I look forward to hearing from you, and I am confident my results will meet your requirements and expectations.

    ASP, Java, Javascript, and XML