InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 22:33:38 GMT20http://www.sqlservercentral.com/Forums/Topic1375397-392-1.aspxThanks GilaMon, 22 Oct 2012 23:33:11 GMTCelestialhttp://www.sqlservercentral.com/Forums/Topic1375397-392-1.aspxI would guess because backup statements are checked for validity when they run. Two very different statements, you shouldn't be surprised they act differently (one's DDL the other maintenance)Mon, 22 Oct 2012 08:22:37 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1375397-392-1.aspx@GilaThen why this code be executed successfully.IF 1 <> 1BEGIN BACKUP DATABASE tempdb TO DISK ='D:\tempdb.bak'ENDMon, 22 Oct 2012 07:32:03 GMTlionofdezerthttp://www.sqlservercentral.com/Forums/Topic1375397-392-1.aspxIf you really want, you can code it like that:[code="sql"]IF 1 <> 1BEGIN EXEC ('ALTER DATABASE TempDB SET RECOVERY SIMPLE WITH NO_WAIT')END[/code]Mon, 22 Oct 2012 07:05:30 GMTEugene Elutinhttp://www.sqlservercentral.com/Forums/Topic1375397-392-1.aspxBecause the validity of the statement is checked before it's actually run.Mon, 22 Oct 2012 06:50:56 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1375397-392-1.aspxHi, I am confused about belwo statment. Although, Recovery model of TempDB can’t be changed but Why this simple IF condition fails?IF 1 <> 1BEGIN ALTER DATABASE TempDB SET RECOVERY SIMPLE WITH NO_WAITENDplease help meMon, 22 Oct 2012 06:48:08 GMTCelestial