Showing posts with label ms sql server 2005 logs full. Show all posts
Showing posts with label ms sql server 2005 logs full. Show all posts

Tuesday, August 31, 2010

Transaction logs growing out of control?

login to SSMS and click new query :
backup log adventureworks with truncate_only

next, right click database adventureworks>tasks> shrink> files>file type > logs> click ok
thats it --only ms SQL server 2005