June 3, 2011 at 7:01 am
How can i restore sql 2008 backup on sql 2005,i have no other option but have to find some alternative to do this, any suggestions?
June 3, 2011 at 7:06 am
use copy database wizard
----------
Ashish
June 3, 2011 at 7:32 am
I found a useful link in sqlservercentral itself, see below. There is a good discussion.
http://www.sqlservercentral.com/Forums/Topic584539-357-1.aspx
M&M
June 3, 2011 at 7:40 am
In SQL 2008 you can generate scripts that contain both the structure and data, depending on the size of the db this may be the easiest option
Just make sure that you do not have any 2008 only features in the scripts before you run them on the 2005 database.
June 3, 2011 at 7:42 am
crazy4sql (6/3/2011)
use copy database wizard
That was an interesting suggestion, that I've never come across before, so I thought I'd give it a go.
I get "The database 'TestDB' cannot be opened because it is version 661. This server supports version 612 and earlier. A downgrade path is not supported."
Have you tried this method yourself, and if so, how did you get past that?
BrainDonor.
June 3, 2011 at 7:42 am
no we can't restore 2008 backup in 2005 backup
this type of message comes
TITLE: Microsoft SQL Server Management Studio
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
The media family on device 'XXXXXXXXXXXXXXXXX' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3241&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
June 3, 2011 at 7:53 am
Change is Required (6/3/2011)
no we can't restore 2008 backup in 2005 backup
Correct - there are an inordinate number of discussions here showing why it cannot be done. It is never possible to restore a later version to an earlier one because the file format changes between versions.
The link provided by Mohammed Moinudheen shows such a discussion.
BrainDonor.
June 3, 2011 at 7:56 am
[
I get "The database 'TestDB' cannot be opened because it is version 661. This server supports version 612 and earlier. A downgrade path is not supported."
you might have ignored the option where you have the option to select type 2005
The exact clue not hitting me now but I will be able to tell you on monday when I will have my test server with me.
----------
Ashish
June 3, 2011 at 8:10 am
crazy4sql (6/3/2011)
[
I get "The database 'TestDB' cannot be opened because it is version 661. This server supports version 612 and earlier. A downgrade path is not supported."
you might have ignored the option where you have the option to select type 2005
The exact clue not hitting me now but I will be able to tell you on monday when I will have my test server with me.
That explains it - you're describing the 'Advanced' option of the 'Generate Scripts' wizard, not the 'Copy Database' wizard. There's an option when generating the scripts to select the target version, Copy Database has no such option.
BrainDonor.
June 3, 2011 at 8:18 am
I find the copy database wizard to be so buggy that it is not really that useful,
others may have had better experience with it, but I would avoid.
June 3, 2011 at 8:23 am
That explains it - you're describing the 'Advanced' option of the 'Generate Scripts' wizard, not the 'Copy Database' wizard. There's an option when generating the scripts to select the target version, Copy Database has no such option.
i think you are correct, sorry about confusion. But I will still need to have a look.
----------
Ashish
June 4, 2011 at 4:48 am
Tara-1044200 (6/3/2011)
How can i restore sql 2008 backup on sql 2005,i have no other option but have to find some alternative to do this, any suggestions?
Have a look : Restoring a database from higher version to lower version SQL server
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply