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);
Last modified: May 18, 2021

Author

Comments

Write a Reply or Comment