Advanced Search

Return to Snippet

Revision: 10148
at December 10, 2008 02:55 by robe
Initial Code 
backup log somedb with truncate_only
use somedb
sp_helpfile  --this provides a list of files used by current db
dbcc shrinkfile('somedb_log', 3)
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
SQL Server truncate log and shrink file

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL