June 25, 2010 at 11:20 am
What are the ways 2008 backup could be restored on 2005 server?
Thanks!
June 25, 2010 at 11:25 am
I don't think it's possible. In order to go backward, you'll need to copy objects and data out of 2008 and back in to 2005. The 2005 server doesn't understand the 2008 server backups.
You might also be able to set up replication between the two and copy the structures that way.
June 25, 2010 at 11:34 am
You cannot restore downlevel. You cant' restore SQL SErver 2008 R2 to SQL Server 2008, you can't restore 2008 to 2005, 2005 to 2000, etc. The structures and database versions change.
You would have to move all the data and objects with scripting.
June 25, 2010 at 12:09 pm
That's what we did. Scripted all db objects and then scripted all the data.
It just seems like very inefficient way to do this. Almost like going from Vegas to San Francisco through New York.
June 25, 2010 at 1:33 pm
mark.dba (6/25/2010)
It just seems like very inefficient way to do this.
It's the only way to do it. There's no way to downgrade a database (2008-2005). System tables, page layout, database version all changed and SQL 2004 doesn't understand the 2008 format.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply