SQL Server - BACKUP LOG WITH NO_LOG
Posted by: SQL Server DBA,
on 22 Jan 2012 |
View original | Bookmarked: 0 time(s)
The BACKUP LOG WITH NO_LOG and WITH TRUNCATE_ONLY options are discontinued in SQL Server 2008.There is no replacement for this functionality. When the command is executed there is the message suggesting to switch to Simple Recovery.Of course , a SQL Server DBA knows that this breaks the Log Chain, and a full backup is required to start a new Log Chain.There are plenty of DBA scripts in Production environments that use BACKUP LOG WITH NO_LOG in SQL Server 2005 . Some thoughts to consider:1) NO_LOG...