Monday, November 22, 2010

how to truncate only log file in MS SQL DB

Run following Script
  •             backup log <dbname> with truncate_only
than do below task
  • Right click on database --> Task --> shirnk -->  file 
  • select log file in file type than click on OK

No comments:

Post a Comment