Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009
    Posts
    1

    Unanswered: SQL Server 2008 Database Truncated?

    Hi All,

    I have a 26MB database that used to contain tables and SProcs and more, which after a reformat of the server attaches successfully, but contains no tables, SProcs, or other data.

    Some backstory: I have an SQL server 2008 database that I upgraded from sql 2005 not too long ago. One of the Windows Updates borked my registry permissions on CLSID and I had to reformat the machine. I booted from a Ubuntu 9.04 CD and copied all of the databases and files from that machine onto a USB flash drive, and reformatted the server, since I wasn't sure of the problem at that time. It could have been a virus for all I knew... once I had the same issue on my laptop, I knew how to fix it and then wished I had never reformatted.

    I reinstalled Windows 2003 Server on the box, reinstalled all my programs (VS2008, SQL2008, etc). I attached all 5 of my databases on this server. All of the databases save the one in question work fine - all data and procedures are intact. The "truncated" DB's file size is 26MB, and its log is 3MB. Running a DBCC CHECKDB returns no problems. Selecting all tables using SELECT * FROM sys.tables returns no records. There are no SPs, built-in or not.

    I don't care about the data in this table as much as the functions, SPs, table structures and indexes. Am I screwed, or can some of this information be retrieved?

    No, I didn't make backups *facepalm*

    - Derreck

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    reformatted. no backups. sorry dude.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •