Microsoft Product Support

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Monday, 18 February 2013

Successfully Shrink Database Log File (*.ldf) in SQL 2005

Posted on 21:46 by Unknown
This may also work in other versions of SQL, but I've not tested it.

First, back the database up. I'm assuming you can figure out the details of backing up. I normally backup to disk and create a new file for the backup in a set backup location/drive/disk.


Then, set the database to use simple backup mode, as seen in the drop-down list in the image below.


Finally, shrink the database, ensuring you select the Reorganize files... option. Select a minimum freespace of anywhere from 0 to 20. If it is low, you are likely to see some instant growth in your database. If it is too high, you're wasting space.




Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Posted in database, ldf, log file, shrink database, simple backup, SQL, SQL server | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

Categories

  • access
  • acl
  • active directory
  • Active Directory Federation Services
  • AD
  • add mailbox
  • ADFS
  • ADFS 2.0
  • antivirus
  • Apple
  • automatic configuration
  • BIOS
  • black and white
  • black screen
  • browser
  • bulk import
  • bulk user import
  • cache
  • check
  • Cisco
  • click to run
  • click-to-run
  • clipboard
  • colour
  • command line
  • Compatibility Support Module
  • computer
  • configuration wizard
  • control panel
  • copy
  • CSM
  • data migration
  • database
  • delete
  • desktop
  • detect
  • DirectAccess
  • domain
  • dsquery
  • duplex
  • edition
  • email address
  • embedded database
  • endpoint protection
  • endpoint protection manager
  • error
  • exchange
  • exchange 2003
  • exchange 2007
  • exchange 2010
  • file
  • firewall
  • folder redirection
  • force
  • GASFO
  • Google Apps
  • Google Apps Sync for Outlook
  • GPO
  • group policy
  • inline editor
  • installation
  • IPv6
  • Java
  • java update
  • join domain
  • ldf
  • Legacy Boot
  • libraries
  • library
  • log file
  • Lync
  • Lync Server
  • Lync Server 2010
  • Lync Server 2013
  • Mac
  • mail relay
  • mailbox
  • mailbox creation
  • mailbox setup
  • mailbox statistics
  • Microsoft
  • microsoft##SSEE
  • minimised
  • minimized
  • multicast
  • netdom
  • network
  • Network and Sharing Centre
  • new mailbox
  • new window
  • NIC
  • Office 2013
  • Office 365
  • offline files
  • old computer accounts
  • old computers
  • old user accounts
  • Outlook
  • Outlook 2013
  • pac
  • paste
  • pop-out
  • powershell
  • prerequisites
  • print
  • Print Defaults
  • Print Preferences
  • print server
  • print settings
  • printer
  • Private Network
  • proxy
  • Public Network
  • rdp
  • re-appearing
  • reappearing
  • recover
  • recovery
  • registry
  • remote
  • remote connection
  • remote management
  • Remote Web Workplace
  • restart
  • restore
  • restrict
  • routing
  • RWW
  • sbs
  • sbs 2008
  • sbs 2011
  • scripts
  • Secure Boot
  • SEP
  • SEPM
  • service
  • sharepoint
  • shrink database
  • simple backup
  • site-to-site
  • slow
  • SQL
  • SQL server
  • support
  • Symantec
  • Symantec Endpoint Protection Manager
  • timeout
  • trust relationship
  • UEFI
  • USB
  • user
  • user data
  • version
  • virtual labs
  • VPN
  • wds
  • Windows 2003 domain
  • Windows 2008 R2
  • Windows 7
  • Windows 8
  • windows deployment services
  • windows internal database
  • windows update
  • WMI
  • WSUS

Blog Archive

  • ▼  2013 (35)
    • ►  November (3)
    • ►  October (1)
    • ►  September (3)
    • ►  August (3)
    • ►  July (2)
    • ►  June (3)
    • ►  May (1)
    • ►  April (6)
    • ►  March (1)
    • ▼  February (10)
      • Lync Resources
      • Microsoft Support - New Zealand
      • Lync Server Labs
      • Get Exchange Mailbox Stats
      • Successfully Shrink Database Log File (*.ldf) in S...
      • Connecting Windows 8 to SBS 2008/2011 RWW
      • Great AD Management Tools
      • Use Group Policy to Restrict Access to USB
      • Sweet Java Install Automation
      • Symantec Endpoint Protection Has Detected Pending ...
    • ►  January (2)
  • ►  2012 (15)
    • ►  December (4)
    • ►  November (3)
    • ►  October (3)
    • ►  September (3)
    • ►  May (2)
Powered by Blogger.

About Me

Unknown
View my complete profile