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! Mike Mike

HI, Refer this link. http://forums.asp.net/t/1474032.aspx/1 I hope this will help you out. Thanks, Rahul Rashu

Hi Rahul, I backed up using SharePoint STSADM. How do I get them restored to SQL Server if not via SharePoint? MikeMike

HI, If you want to do this via sql script refer this: http://blog.sqlauthority.com/2007/02/25/sql-server-restore-database-backup-using-sql-script-t-sql/ If you want to do this manually refer this: http://msdn.microsoft.com/en-us/library/ms177429.aspx I hope this will help you out. Thanks, Rahul Rashu