SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
Screenshot of files, location & DBs in Microsoft SQL Server Management Studio Express GUI:
I've looked at several answers and tutorials on how to clear out the LDF via GUI and SQL commands, but that is assuming the DB is visible.
Via GUI I went to:
DB SBSMonitoring > Tasks > Delete > Log files and gain about 1-2 GB space.
It's location on disk is: C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data
What steps can I take to add this DB/ or clear out without adding?
Shrink the log files using the following statement. Do this OUT OF OFFICE HOURS!
-- Connect to the database that you want to shrink
USE <DATABASENAME>;
-- Set the recovery model to SIMPLE
ALTER DATABASE <DATABASENAME> SET RECOVERY SIMPLE;
-- Issue a CHECKPOINT to purge out the inactive transactions
CHECKPOINT;
-- Shrink the transaction log file to a reasonable size
DBCC SHRINKFILE (<LOGICAL NAME OF LDF>, 5);
-- Set the recovery model back to FULL
ALTER DATABASE <DATABASENAME> SET RECOVERY FULL;
You can find out the logical file name for the database using:
USE <DATABASENAME>;
SELECT Name FROM sys.database_files
