Advanced Search

Return to Snippet

Revision: 41008
at February 10, 2011 20:40 by scholli
Initial Code 
Declare @LogFileLogicalName sysname
select @LogFileLogicalName=Name from sys.database_files where Type=1
print @LogFileLogicalName

DBCC Shrinkfile(@LogFileLogicalName,100)
Initial URL 
http://madhuottapalam.blogspot.com/2008/05/faq-how-to-truncate-and-shrink.html
Initial Description 

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
SQL Server 2008 Truncate Transaction Log

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql, server

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL