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 |  
                                    | AskSQLTeamAsk SQLTeam Question
 
 
                                        0 Posts | 
                                            
                                            |  Posted - 2006-11-10 : 08:16:41 
 |  
                                            | catcat writes "Hi All,Our MSSQL 2000 server crashed yesterday and one database cannot be restored. the latest backup we have is june.  We can only recover the MDF file from the harddisk and according to our admin, it cannot be restored anymore because no proper shutdown was made.Will appreciate your help here." |  |  
                                    | Michael Valentine JonesYak DBA Kernel (pronounced Colonel)
 
 
                                    7020 Posts | 
                                        
                                          |  Posted - 2006-11-10 : 09:45:12 
 |  
                                          | Call Microsoft Support to ask if they can help you with the MDF.Setup proper backups so this doesn't happen again.CODO ERGO SUM |  
                                          |  |  |  
                                    | KristenTest
 
 
                                    22859 Posts |  |  
                                |  |  |  |