Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate

Autor Topic: Limpiar Base de latos de log  (Visto 415 veces)

0 Miembros and 1 Guest are viewing this topic.

Offline ISAER HOST Posteado: February 07, 2025, 08:53:32 PM

  • 0 puntos por ventas
  • *
  • Rank: Principiante
  • Posts: 4
  • Gracias recibida: 0
  • ar
Reduccion de base de datos por quary (Cambiar el nombre de la Base de datos  "MuOnlineS6", Por la que tengas usted!
Crear carpeta "test" en disco C:\       Musicx2
Paso 1

Backup log MuOnlineS6
to disk  =‘C:\test\BackupLog.bak’

Paso 2

sp_helpdb MuOnlineS6

Paso 3

ALTER DATABASE MuOnlineS6
SET RECOVERY SIMPLE;
GO

Paso 4

DBCC SHRINKFILE(MuOnlineS6_Log, 1);
GO

Paso 5

ALTER DATABASE MuOnlineS6
SET RECOVERY FULL;
GO


Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate


 

Related Topics

  Subject / Started by Replies Last post
8 Replies
4362 Views
Last post November 19, 2016, 10:56:20 PM
by jigokush
2 Replies
1874 Views
Last post January 26, 2019, 02:38:12 PM
by STARTS
0 Replies
629 Views
Last post September 06, 2019, 12:24:14 AM
by Rescate
1 Replies
1298 Views
Last post April 05, 2020, 08:43:29 PM
by enriquexp
2 Replies
2922 Views
Last post March 25, 2025, 09:27:13 AM
by tupa110