USE MyDATA
GO
DBCC SHRINKFILE('MyDATA_log', 1)
BACKUP LOG MyDATA WITH TRUNCATE_ONLY
DBCC SHRINKFILE('MyDATA_log', 1)
GO
On sql server 2008, To remove database log
https://www.brentozar.com/archive/2009/08/backup-log-with-truncate-only-in-sql-server-2008/
BACKUP LOG martinrobson TO DISK='NUL:'
GO
DBCC SHRINKFILE('MyDATA_log', 1)
BACKUP LOG MyDATA WITH TRUNCATE_ONLY
DBCC SHRINKFILE('MyDATA_log', 1)
GO
On sql server 2008, To remove database log
https://www.brentozar.com/archive/2009/08/backup-log-with-truncate-only-in-sql-server-2008/
BACKUP LOG martinrobson TO DISK='NUL:'
No comments:
Post a Comment