>You cannot turn transaction log off because it's used by SQL Server internally even in Simple mode. You can set 'Auto Shrink = True' in the DB options.
If I do this, would that have any impact on the backup? Because, this has been reported in another message.