Restoring Backup for SQL Server 2005

When attempting to restore a back up of a database from a file using the discountasp control panel, I get the following error:

'Restore failed. The database backup file contains more than one data file. You cannot restore database backup (.bak) files with more than one data file.'

I have restored successfully in the past from one of the files I have tried, and the files I have tried restoring from only have the one data file.

Has anyone else had these problems?

Duncan

 

I am having the same problem but cannot figure out how to remove the free text table from the backup. How can this be done?

Once I do the upload, how do I reset the freetexttable to start indexing again?

 

You can't remove directly from the backup. You must remove it from the working database source, then make another backup. This knowledgebase article shows how to find it in SQL Management Studio, and on how to create a new one.

http://kb.discountasp.net/article.aspx?id=10467

Aristotle

DiscountASP.NET
www.DiscountASP.NET