Can never remember the syntax so here is is as a reminder:
Make the database current then run
DBCC
SHRINKFILE(‘Foo_LOG’,1)
BACKUP
LOG Foo WITH TRUNCATE_ONLY
DBCC
SHRINKFILE(‘Foo_LOG’,1)
go
My little part of the Internet
Can never remember the syntax so here is is as a reminder:
Make the database current then run
DBCC
SHRINKFILE(‘Foo_LOG’,1)
BACKUP
LOG Foo WITH TRUNCATE_ONLY
DBCC
SHRINKFILE(‘Foo_LOG’,1)
go
© 2024 Kevsters Blog
Theme by Anders Norén — Up ↑
Leave a Reply