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 |  
                                    | paruchuri4Starting Member
 
 
                                        1 Post | 
                                            
                                            |  Posted - 2012-09-25 : 15:30:12 
 |  
                                            | Hi,I want to estimate the transaction log size before taking backup,  not the used space.Thanks |  |  
                                    | chadmatThe Chadinator
 
 
                                    1974 Posts | 
                                        
                                          |  Posted - 2012-09-25 : 16:57:31 
 |  
                                          | select * from sysfiles-Chad |  
                                          |  |  |  
                                |  |  |  |