Friday, September 6, 2019

reducir el tamaño del log.

ALTER DATABASE TUBBDD
SET RECOVERY SIMPLE;
GO

DBCC SHRINKFILE(TUBBDD_Log, 1);
GO

ALTER DATABASE TUBBDD
SET RECOVERY FULL;
GO

No comments:

Post a Comment