BACKUP DATABASE [MyDB01]
TO DISK = N'C:\MSSQL\MyDB01_Full_20210315.bak' WITH NOFORMAT, NOINIT, NAME = N'Full Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
BACKUP LOG [MyDB01] TO DISK='C:\MSSQL\MyDB01_Log_20210219a.bak' WITH NO_CHECKSUM, CONTINUE_AFTER_ERROR
Use [MyDB01]
DBCC SHRINKFILE (MyDB01log, EMPTYFILE);
Comments