SQL Server - Optimizar una base de datos SQL

USE TuBaseDeDatos;

GO

-- Reducir la base de datos

DBCC SHRINKDATABASE (TuBaseDeDatos, 10);

GO

-- Truncate the log by changing the database recovery model to SIMPLE.

ALTER DATABASE TuBaseDeDatos

  SET RECOVERY SIMPLE;

GO

-- Shrink the truncated log file to 1 Mb.

DBCC SHRINKFILE (TuBaseDeDatos, 1);

GO

-- Reset the database recovery model.

ALTER DATABASE TuBaseDeDatos

  SET RECOVERY FULL;

GO