Database Optimization: Purging SQL Logs (LDF)

Published by david on

Command SQL

ALTER DATABASE [YourDatabaseName] SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKDATABASE ([YourDatabaseName], 1, TRUNCATEONLY)
ALTER DATABASE [YourDatabaseName] SET RECOVERY FULL WITH NO_WAIT

Categories: SQL
Tags:

0 Comments

Leave a Reply

Avatar placeholder

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related Posts

SQL

SQL and MDT: Firewall Configuration

Configure your firewall for SQL and MDT integration

SQL

How to Modify Over 200 Rows in SQL Management Studio

Learn the step-by-step process to efficiently modify more than 200 rows in SQL Management Studio. Discover how to adjust settings in the SQL Server Object Explorer to increase the default row limit

SQL

Searching Column Names in SQL Tables

Search for column names across all SQL tables using a straightforward query. This method offers a quick way to locate specific columns within your SQL database.