I am working on a startup company and the "dba" recently quit...come to find out he let the LDF file grow to 105GB - which effectively shut down the server due to lack of disk space. I need to serious help as this database is also supporting our replication
system and thus I cannot do anything drastic like detaching, deleting the LDF file and reattaching.
I tried the shrink file option but the LDF file did not shrink at all. I set the recovery model to simple, then tried shrinking and that did nothing. This is a SQL Server 2008 machine - can somebody please help?
Also, given that I am mainly a developer, is there some EASY reference on how to setup log file backups so this does not happen in the future? Do I just perform a full backup every 30 minutes over-writing the previous backup, differentials, what?
View Complete Post