I am trying to set up a full text search on a table in SQL Server 2008 R2. My table looks like this According to what I have read I need to create a "unique, single-column, non-nullable index". When I try to create the index on the FText field everything is grayed out so I cannot do it.
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.