We are using Sql 20082 Standard edition. Data drive has enough free space but that table stores the errors that we don't required to store more than 3 months.

To do this data archiving we need to have linked server otherwise we can't able to do that process b/n servers