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 |  
                                    | HommerAged Yak Warrior
 
 
                                        808 Posts | 
                                            
                                            |  Posted - 2013-06-05 : 11:15:35 
 |  
                                            | Hi,will restart the server cause problem if it is in recovering?I checked both mdf and lof has space and last tlog backup did not go through. then it is in recovering.Thanks! |  |  
                                    | HommerAged Yak Warrior
 
 
                                    808 Posts | 
                                        
                                          |  Posted - 2013-06-05 : 11:54:06 
 |  
                                          | Ok, restart came to rescue one more time.Now down to the path chasing the root cause for the tailspin... |  
                                          |  |  |  
                                    | prettPosting Yak  Master
 
 
                                    212 Posts | 
                                        
                                          |  Posted - 2013-06-19 : 07:05:33 
 |  
                                          | You should wait till recovery process get completed. There are multiple reasons behind this issue. Please check this post for more detail: http://data-base-recovery.blogspot.com/2012/07/is-your-sql-database-showing-in.html |  
                                          |  |  |  
                                    | ahmeds08Aged Yak Warrior
 
 
                                    737 Posts | 
                                        
                                          |  Posted - 2013-06-19 : 12:30:54 
 |  
                                          | Also,please run the database consistency check on the database after server restart.just to make sure if everything is right.mohammad.javeed.ahmed@gmail.com |  
                                          |  |  |  
                                |  |  |  |