Hello Greg,

the easiest way to make sure the full-text-indexed column is up to date is a trigger that is executed on every insert or update operation of your table. As...

Dammit, once again! So creating a non-clustered index on the date column is wrong... sorry, I can see no advantage in creating the clustered index on the date column...

No, for two reasons:

1. the question was about creating a backup by executing the BACKUP statement manually - not as an SQL Server Agent job. You don't need...