Backup Error

• Leo-696352

  SSCrazy

  Points: 2708

  More actions

  April 2, 2009 at 10:55 am

  #208139

  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

• maechismo_8514

  SSCoach

  Points: 17510

  More actions

  April 2, 2009 at 5:39 pm

  #971216

  Hi,

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

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

• Leo-696352

  SSCrazy

  Points: 2708

  More actions

  April 3, 2009 at 2:25 am

  #971348

  Sorted. Thanks.

  Leo