SELECT name, size FROM sys.database_files;
USE Base_datos
GO
CHECKPOINT
GO
CHECKPOINT
GO
CHECKPOINT
GO
BACKUP LOG Base_datos WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE (basedatos_db_log)
USE Base_datos
GO
CHECKPOINT
GO
CHECKPOINT
GO
CHECKPOINT
GO
BACKUP LOG Base_datos WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE (basedatos_db_log)
Comentarios
Publicar un comentario