Backup Log - Truncate the logs at SQL 2005, 2008, 2012, 2014

--// To version before 2008 or upper
BACKUP LOG  [Database_name] WITH TRUNCATE_ONLY

DBCC SHRINKFILE (  databasename_Log, 1)


--// To version after 2005
BACKUP LOG [Database_name] DynamicsGPWarehouse TO DISK='NUL:'

Etiquetas: