Unsolved
This post is more than 5 years old
2 Intern
•
225 Posts
0
682
June 6th, 2012 00:00
How restore SQL DB to lower version?
IHAC like to get back from SQL 2010 to 2008, due to issues happening during using 2010.
When restore the DB backed up on 2010 to a new installed 2008 server, error occurred and error # is 3241.
Any workaround?
No Events found!
Michael_Morris
18 Posts
0
June 6th, 2012 03:00
Hi Eddy
Take it you actually mean SQL Server 2012 rather than 2010.
If you restore a backup from a lower version to SQL Server 2012 the database will be automatically upgraded and so you'd have to expect not to be able to take a backup from 2012 and restore it to a 2008 instance.
For a work around you can export the data using SSIS, BCP or maybe try a thrid party tool to sync data between the two database versions such as redgate's SQL Data Compare, there are free tools out there to do this but redgates software is available as a 14 day trial download.These kind of data comparison tools are a good way to keep data in sync as you test compatability prior to commiting yourself to an upgrade of a production environment.
Is this actually a real issue or are you just reading articles such as below ?
http://bestvisualization.blogspot.com/2011/07/3241-error-using-ms-sql-2008.html
http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/797cbb2a-f339-435c-a46f-79c4fe33d40d
Michael