Showing posts with label version. Show all posts
Showing posts with label version. Show all posts

Thursday, February 16, 2012

backup

Hai,

I have taken back of sql2005 beta 2 version. But now i am unable to restore it sql2005 original version.

it is displaying the error incompatable version.

Please let me know how i can restore the backup from sql2005 beta 2 version to sql2005 original version.

regards

Suresh S

I think Microsoft made some breaking changes between Beta2 and RTM. I think you will have to script the schema from the Beta2 and create a new blank database in SQL Server 2005 RTM (or later), then use Integration Services to copy your data. Visual Studio 2005 for Database Professionals (Datadude), can automate much of this.