Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 backup issue

Author  Topic 

AgaK
Yak Posting Veteran

86 Posts

Posted - 2009-12-10 : 17:11:39
Hi,

I am getting the following error message when I try to backup a db:

System.Data.SqlClient.SqlError
The backups of full-text catalog '....' is not permitted because is not online.

I can backup other dbs on the same server without any problems.

Any ideas how to fix this?

thank you

Aga

rajasekhar857
Constraint Violating Yak Guru

396 Posts

Posted - 2009-12-11 : 12:58:46
Click on the Particlular database storage option will come go into that.in that full text catalogs option will come.There you can see one name right click on that.Give Delete and take backup.will works fine.There is nothing u can loose by doing so.
Go to Top of Page

AgaK
Yak Posting Veteran

86 Posts

Posted - 2009-12-14 : 15:43:33
the full-text was offline, I had to enable it and it worked.
Go to Top of Page
   

- Advertisement -