Sql-server – How to create via sql and detect via ERRORLOG SQL Server 2008 Deadlocks

1. Create a ft catalog
2. Create a filegroup for your ft index
3. Create a file in the filegroup you created above on the drive you want the ft index on
4. Right-click on the table you want to create the ft index for
5. Select Full-text Index -> Define Full-text index...
6. On the first page of the wizard, click Next
7. Select the unique index to use, click Next
8. Select the columns to index, click Next
9. Select the preferred change tracking, click Next
10. Select the ft catalog you created
11. Use the Select index filegroup pulldown to select the ft filegroup you created
12. Click Next
13. Create a schedule if you wish, click Next
14. Click Finish, click Close
15. Richt-click the table, select Full-text Index -> Properties
16. Verify the correct filegroup is indicated

You should fix the SQL agent first.

as a temporary workaround, you can use SQLCMD and schedule it using windows scheduler for doing backups.

no need to spawn a job from different server and do the backup on another server.