Register   |   Login   |   February 08, 2012    |   Knowledge Base  >  Knowledge Base Systems  >  MSSQL  >  shrink log file
search:     

Phone: 480-722-1227
Toll Free: 888-722-1227

shrink log file
Last Post 23 Jan 2008 04:46 PM by Chris Muench. 0 Replies.
Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Chris MuenchUser is Offline
New Member
New Member
Posts:57

--
23 Jan 2008 04:46 PM  

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.

Active Forums 4.2
Copyright 2006 - 2011 Vigilant Support   |  Privacy Statement  |  Terms Of Use