34. Reducir el Tamaño de la BD

Published: 07 September 2018
on channel: Denis Guido

17,426

173

Aportes al Canal Via PayPal : https://paypal.me/denisenrique?locale...

/*Informacionde la BD*/
sp_helpdb BDVENTAS5
/* Antes de truncar el log cambiamos el modelo de recuperación a SIMPLE.*/
ALTER DATABASE BDVENTAS5 SET RECOVERY SIMPLE;
GO
/*Reducimos el log de transacciones a 0 MB.*/
USE [BDVentas5]
GO
DBCC SHRINKFILE (N'BDVentas_log' , 0, TRUNCATEONLY)
GO
DBCC SHRINKFILE (N'BDVentas')
/*Cambiamos nuevamente el modelo de recuperación a Completo.*/
ALTER DATABASE BDVENTAS5 SET RECOVERY FULL;

CUPONES DE DESCUENTO, TODOS LOS CURSOS A $9.99
https://www.udemy.com/aprende-a-crear...

https://www.udemy.com/administracion-...

https://www.udemy.com/optimizacion-de...

https://www.udemy.com/master-en-consu...

https://www.udemy.com/administracion-...

Watch video 34. Reducir el Tamaño de la BD online without registration, duration hours minute second in high quality. This video was added by user Denis Guido 07 September 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 17,426 once and liked it 173 people.

1,106