SQL server backup problem

When you make a backup of your SQL Server database you get the following error:

TITLE: Microsoft SQL Server Management Studio
——————————

Backup failed for Server ‘localhost’.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=
Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&
EvtID=Backup+Server&LinkId=20476

——————————
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The backup of the file or filegroup "sysft_SearchCatalog" 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)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&LinkId=20476

 It’s because of your Full Text Catalog offline or the parameter incorrect. For my case, I used my local design path but this path doesn’t exist on live server and get the above error when backup. You can generate the sql query to view the source.

Solution: you can simply delete the catalog or rebuild it (expand your db > Storage > Full Text Catalog)

Share

- has written 121 posts.


Leave a Reply

You must be logged in to post a comment.