Database Backed up on 2008, restore on 2000?

Question

Post reply

Database Backed up on 2008, restore on 2000?

Garadin

One Orange Chip

Points: 29613
More actions
December 3, 2009 at 11:16 am

#385885

Working on too many things at once, and I may have screwed up.
I backed up our SQL 2000 SP2 database to a file.
Copied that file over to our 2K8 server and restored it. (Compat Mode 80)
I made some changes to the data, added a few clustered indexes etc.
Backed up the database from the 2008 server to a file.
Zipped the file
Moved the file to another server and unzipped it.
Attempting to restore the database on a 2000 SP3 server is giving errors such as:
Too many backup devices specified for backup or restore; only 64 are allowed
My question is, should this work? I really don't deal with backups and such much, so I don't know if having backed it up from 2K8 causes a problem when restoring it to 2K.
Seth Phelabaum
Consistency is only a virtue if you're not a screwup. 😉
Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 1

One thing is for sure, Backup of SQL 2008 Database will not restore in SQL 2000.

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

Garadin One Orange Chip Points: 29613 More actions · Answer 2

Yeah, I think I should have googled first, asked the question afterwards. The database is restoring fine on another 2008 server, and a quick google informs me that the backup data structure changed between versions.

Seth Phelabaum

Consistency is only a virtue if you're not a screwup. 😉

Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

Joie Andrew One Orange Chip Points: 27360 More actions · Answer 3

Yeah, it would probably be easier to create an empty database on the 2000 box and setup something like a DTS/SSIS package to have the data from the 2008 machine pushed into the 2000 box.

Joie Andrew
"Since 1982"

Garadin One Orange Chip Points: 29613 More actions · Answer 4

I can't get the term 'That guy' out of my head right now. I think you'd probably find a warning against this in chapter one of 'Beginning Database Administration for Dummies'. I really need to expand my knowledge of all the things I lump into the pool of 'dba stuff' and ignore. Ugh. :blush:

Seth Phelabaum

Consistency is only a virtue if you're not a screwup. 😉

Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Garadin (12/3/2009)
a quick google informs me that the backup data structure changed between versions.

Not just the backup file structure. The actual database file structure. It is not possible to restore or attach a DB to a lower version.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass