SharePoint 2007 Restore Error RRS feed

  • Question

  • Hi,

    I'm getting this error while trying to restore a content database in SharePoint 2007.

    SqlException: The file 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\ix_Corporat1_SITE' cannot be overwritten.  It is being used by database 'SPS_Content_Site'.
    File 'sysft_ix_Corporat1_SITE' cannot be restored to 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\ix_Corporat1_SITE'. Use WITH MOVE to identify a valid location for the file.
    Problems were identified while planning for the RESTORE statement. Previous messages provide details.
    RESTORE DATABASE is terminating abnormally.

    It seems to me that the SQL Full Text Query is using the database ix_Corporat1_SITE. Do I need SQL Full Text Query? I tried disabling it, but it automatically restarts the service the moment the restore operation runs.

    I used STSADM -o restore (catastrophic Backup) to run backup.

    Thanx in advance!


    • Edited by Mike Walsh FIN Friday, July 15, 2011 11:16 AM : unnecessary in Title
    Friday, July 15, 2011 3:03 AM


All replies