March 31, 2006 at 9:57 am
Hello
I'm getting a new error when trying to restore a backup of a 2005 DB onto a 2000 server.
Error 3205: Too many backup devices specified for backup or restore; only 64 are allowed.
RESTORE FILELIST is terminating abnormally.
---------------------------
Sorry if this is a re-post I've searched this forum and found no topics for it.
Of course we're deploying today but the BETA server never got it's upgrade from the admins. Please help.
much appreciated!
Skål - jh
April 3, 2006 at 8:00 am
This was removed by the editor as SPAM
April 3, 2006 at 1:07 pm
Please post the code you are trying to run. Here is an example where someone tried to restore a full back up and a bunch of transaction log backups with one command instead of an individual command for each file:
http://www.mcse.ms/archive81-2005-2-1441606.html
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
April 3, 2006 at 1:28 pm
Thank you guys!
No code to post I was using the EM to restore a DB backup.
My latest guess is the 2005 backups are just totally incompatible with 2000. I tried setting the compatibility level to 8 or 7 on the source 2005 DB and making more backups but nothing worked including data import wizard on the 2000 end.
I ended up scripting out the tables from 2005, parsing it and cleaning the TSQL in 2000 and finally using that to build the empty tables, then I used the data export wizard from the 2005 end to pump the data to the 2000 DB.
I've requested an upgrade on the BETA server to 2005 since DEV and PROD are 2005 it's just going to be continued pain trying to restore the DBs on 2000.
much appreciated!
Skål - jh
April 3, 2006 at 1:33 pm
Yes, I should have read your question closer. You can not go back from 2005 to 2000. I think the approach you came up with is good.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
April 18, 2006 at 11:03 am
Can you restore a backup created a server running sql 2005 64 bit to a to a server running sql 2005 32 bit?
January 14, 2008 at 2:56 pm
I would like to know the answer to that question as well. Can you perform a restore taken from a 2005 64 bit box to a 2005 32 bit box?
January 14, 2008 at 3:40 pm
I just restored a backup from a 64 bit SQL Server 2005 to a 32 bit SQL Server 2005. It worked!
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
January 14, 2008 at 9:00 pm
Can you restore a backup created a server running sql 2005 64 bit to a to a server running sql 2005 32 bit?
Yes. There is no problem in doing this.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply