Welcome to Sign in | Help

sql server 2005 eroare la creare backup - Full-text Catalog

  •  04-23-2008, 2:20 PM

    sql server 2005 eroare la creare backup - Full-text Catalog

    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.

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems