Can't Backup DB or Drop FullText Index

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)

Can't Backup DB or Drop FullText Index

Author

Topic

thavelick
Starting Member

2 Posts

Posted - 2008-03-29 : 20:24:54

I just tried to backup a database I recently deployed to to SQL Server 2005 box, and got the following error:

The backup of full-text catalog 'myCatalog' is not permitted because it is not online. Check errorlog file for the reason that full-text catalog became offline and bring it online.
Or BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.

I don't need the index so I tried to drop it with both:

DROP fulltext catalog 'myCatalog'

and

DROP catalog 'myCatalog'

but both give me a syntax error.

How can I get rid of this index so I can backup my database?

Thanks,

Tristan

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-29 : 20:37:00

check this out:

http://msdn2.microsoft.com/en-us/library/bb326385.aspx
http://www.aspdeveloper.net/tiki-index.php?page=SqlTipsFullTextError
http://support.microsoft.com/kb/923355

thavelick
Starting Member

2 Posts

Posted - 2008-03-30 : 01:37:24

This ended up being a bit silly.. I just needed to run:

drop fulltext catalog mycatalog

without quotes.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources