Restoring Backup for SQL Server 2005

[cre8_duncan]

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

[Eric]

Please submit a support ticket with details.


Eric
DiscountASP.NET
http://www.DiscountASP.NET

[bruce]

this error means that the backup file contains multiple data files which we do not allow.




Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[junior]

if you have a full text index, please remove it.


junior

DiscountASP.NET

www.DiscountASP.NET (http://www.DiscountASP.NET)

[jmag999]

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?

[Aristotle]

jmag999 said...
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 (http://www.DiscountASP.NET)