Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | roxanStarting Member
 
 
                                        1 Post | 
                                            
                                            |  Posted - 2007-02-11 : 02:59:36 
 |  
                                            | Dear all,I have a very critical problem with corrupt database. Our main server got burned yesterday. There were very important data that went lost. We have a old computer that was used as the sql server 2000 before this machine was burned with the fire. We only want the initial data of the database  so we swithched on the old computer but it was formated once. with recover my files we recovered the .mdf and .ldf files. mssqlrecover from officerecovery says recovery done with demo restriction. it recovers all item but the table value which we needed. The databse is of 2.37 mb and when compressed 560 kb.Can anybody please recover the data from the database? |  |  
                                    | mcrowleyAged Yak Warrior
 
 
                                    771 Posts | 
                                        
                                          |  Posted - 2007-02-11 : 10:34:43 
 |  
                                          | I would say recover from your last backup.  Or is your last backup corrupt as well? |  
                                          |  |  |  
                                    | eyechartMaster Smack Fu Yak Hacker
 
 
                                    3575 Posts | 
                                        
                                          |  Posted - 2007-02-11 : 12:19:52 
 |  
                                          | this is the reason you have backups.  For any noobs out there, setting up and testing your backups is the single most important job a DBA does.  Roxan, my advice for you is to contact Microsoft professional support.  They will be your only hope of recoverying any data.-ec |  
                                          |  |  |  
                                |  |  |  |