March 9, 2009 at 6:40 pm
Hey Guys
I'm coming across a strange problem that i have not seen before. Last week our weekly Maintenance plan up plan failed, so i backed it up manually because i had too many things on to have a proper look. Unfortunately it failed again this week with the following error message.
History Log
The backup of full-text catalog 'DB1' 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. (Microsoft.SqlServer.Smo)
The Error Log
2009-03-10 10:56:47.60 Backup BACKUP failed to complete the command BACKUP DATABASE DB1. Check the backup application log for detailed messages.
2009-03-10 11:02:14.84 Backup Error: 3041, Severity: 16, State: 1.
Now when i right click on the DB it tells me its online, its currently being used in replication and its working fine and i have applications that are C.R.U.D. and that's all fine, so i find it hard to believe that its offline.
When i try to backup manually i get the same issue so I'm rather stuck, has anyone had a similar issue or know of a way to fix this?
Cheers 🙂
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!
March 9, 2009 at 9:44 pm
Are you possibly rebuilding the Full Text Catalog at the same time on this database? Check out this link and let us know what you find. Thanks!
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 10, 2009 at 2:09 am
Cheers dude for sending me that link i now know what it is offline. Only problem is i don't know what it is or how to make it online
DB1_DataD:\MSSQL\DATA\DB1.mdfONLINE
Db1_LogD:\MSSQL\DATA\DB1.ldfONLINE
sysft_Db1D:\MSSQL\FT\DB1 OFFLINE
Now this DB was restored from a backup from another server and the FT folder does not exist.
Cheers 🙂
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!
March 10, 2009 at 3:29 am
You should be able to use the "drop fulltext index" then "drop fulltext catalog" statement to get rid of that. Review these in Books Online and you should be able to find all the information you need.
HTH
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply