Error attaching/restoring a DB

Discussion in 'Databases' started by martincad, Aug 24, 2008.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. I have been trying to attach (or restore) my database, and I always gets the same error. (For attaching first I uploaded the database using FTP, and for restoring I uploaded a backuped database).

    The only time I could upload my database was the first one, all the other time I tried, it was impossible.

    The error showed by the system is the following:

    "Failed. Please contact Technical Support immediately and do not perform any additional tasks on your database."


    I opened a lot of tickets, and the response is always the same: "According to our system event log, your database has an offline full text catalog. You will need to remove it in your local environment, create a backup of the database again without the catalog, then restore it on our database server."

    I delete the fulltext indexes, the fulltext Catalog and I also disable Fulltext in the database, but the restore process still fails. Using the following SQL sentences:



    SELECT name, ftcatid FROM sysobjects WHERE ftcatid > 0


    EXEC sp_fulltext_table 'Discount', 'drop'


    EXEC sp_fulltext_table 'Category', 'drop'


    DROP FULLTEXT CATALOG MDCatalog

    Is it possible the real problem is different from the mentioned by the support ?
    Or should I do somethign different to delete the fulltext ?

    Thanks in advance.

    PS: I'm using SQL 2005.
     
  2. If you want to put the DBon-line so I can D/L it I'll load it and take a look for you.
    [email protected]

    I really don't think I'll be able to help much without looking at it.
    You can trust me, I always promise full confidentiality.
    Salute,
    Mark
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page