Backup Error

  • Hello Everyone,

    I am having the following error when I run the backup on my SQL 2005 Server. Please Help.

    Backup failed for Server 'SERVER-05\TEST_SQL2005'. (Microsoft.SqlServer.Smo)

    ADDITIONAL INFORMATION:

    System.Data.SqlClient.SqlError: The backup of the file or filegroup "sysft_TESTING_FULLTEXT" is not permitted because it is not online.

    BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)

    Any Idea?

    Thanks.

    Leo

  • Hi,

    this error message is related to the Full Text catalog, check this KB:

    http://support.microsoft.com/kb/923355

  • Sorted. Thanks.

    Leo

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply