USE basedatos
CHECKPOINT
EXEC sp_addumpdevice 'disk', 'CopiaBaseDatos', 'F:\Backups\DDBB4.bak'
BACKUP DATABASE basedatos TO CopiaBaseDatos
BACKUP LOG basedatos TO CopiaBaseDatos WITH TRUNCATE_ONLY
DBCC SHRINKFILE (basedatos_log)
CHECKPOINT
EXEC sp_addumpdevice 'disk', 'CopiaBaseDatos', 'F:\Backups\DDBB4.bak'
BACKUP DATABASE basedatos TO CopiaBaseDatos
BACKUP LOG basedatos TO CopiaBaseDatos WITH TRUNCATE_ONLY
DBCC SHRINKFILE (basedatos_log)
Comentarios
Publicar un comentario