salut, am si eu o problema cand vreau sa creez un backup full la o baza de date in sql server 2005
eroare este:
the backup of full-text catalog 'NumeFullTextcatalog' is not permited because it is not online
adica asta http://support.microsoft.com/kb/923355
cum fac sa-l aduc online?
am incercat urmatoarele:
SELECT * FROM sysfulltextcatalogs
si am observat ca are ftcatid = 5 si status = 0
pe urma am aflat
SELECT name, physucal_name, state_desc FROM sys.master_files where database_id = 'numeDB'
unde state_desc pt full-text catalog este offline
daca ii dau comanda
exec sp_help_fulltext_catalog 'numeCatalog' imi zice ca:
full-text catalog does not exist in database
am incercat si :
ALTER DATABASE database_name SET OFFLINE
ALTER DATABASE database_name MODIFY FILE ( NAME = logical_name , FILENAME = 'new_path')
ALTER DATABASE database_name SET ONLINE
imi da cu succesfully dar nimic nu se schimba
nu inteleg ce trebuie sa fac...unde este buba....unde gresesc?
multumesc
alex.