Wednesday, March 21, 2012

Restoring problem

When i try to restore my back up i got this error:

Solution?

I'm using SQL 2005 evaluation version, and restore file is generated by SQL 2005 Standard editon.

|||

Hi ozonce,

By "Sql 2005 Evaluation version", do you mean sql express? Based on my understanding and experience, I think the bakup file (*.bak) is compatible in Sql 2005 and Sql Express which means: you can backup your database in sql express and then restore it in sql2005 and vice versa--unless you do NOT specify full text index feature enabled in sql2005 since Full-text index is not supported in sql express. I just make a test to verfiy it: I created a bak file in sql2005 standard version and restored it successfully in sql express. So, there must be some thing wrong in your bak up file or some operation faults. BTW, do you use the same database name between your current database and the backup database ?

Hope my suggestion helps

No comments:

Post a Comment