March 7, 2010 at 11:30 pm
Hi all
i can not take full backup of my database due to this error.
The backup of the file or filegroup "sysft_<databasename>" 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.
Any One Help Me how to we take backup.
March 7, 2010 at 11:57 pm
it is not online
I think it's quite self explaining - get the database Online before trying a Backup through SSMS.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 8, 2010 at 12:13 am
This Database currently in working but we can not take backup.because some file related to full text search (full text catalog) is missing . currently i am not using full text search.so i can remove this catalog and can take backup but why?
March 9, 2010 at 1:19 am
Drop full text catalogs if not required, then perform a backup.
It should help.
Cheers,
- Win.
" Have a great day "
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply