Welcome
Login  |  Register
Monday, January 05, 2009
  Search
You are here:Knowledge Base
 
 
 

 Please Register or login to view our private forums, it is free!!

Subject: shrink log file
Prev Next
You are not authorized to post a reply.

Author Messages
cmuenchUser is Offline
Posts:59

01/23/2008 9:46 AM  

If you have a full log file in sql2005 then do the following.

Open Sql mgmt studio and go the properties of the database.  Then go to Options.  Then change the logging mode to Simple.  Press ok.  Then right click the database and then go to Tasks then to Shrink then Files.

Select the Log file and then you want to click the second choice.  Type in a zero.  Then press ok.  Then you should be good to go.     

You are not authorized to post a reply.
Forums > Knowledge Base Systems > MSSQL > shrink log file



ActiveForums 3.7
 
Copyright 2006-7 Vigilant Support