I am trying to restore a database backed up using SQL Server 2005 Express Edition to a server using MSDE. I get an error 3205 "Too many backup devices specified...64 max..."
I'm only specifying one file for the restore.
Ideas?
Once a database has been attached to a 2005 version it can not be restored to a 2000 version.
MSDE is 2000 and Express is 2005.
WesleyB
Visit my SQL Server weblog @. http://dis4ea.blogspot.com
|||Color me sad...
I control my server completely. If I install 2005 (either express or full version) on my server, will it migrate my existing msde database(s) automatically? Is there a way to do that? I have no problem upgrading as long as I can pull my existing db's up with me.
Can you help me?
Again, thanks for your answer. It's the only definitive answer I've received.
Jim
|||More information about upgrading MSDE to SQL Server Express can be found here: http://www.microsoft.com/sql/editions/express/upgrade.mspx.
Migrating your MSDE to the full version is also a viable option.
From 2000 to 2005 is not a problem only the other way around.
WesleyB
Visit my SQL Server weblog @. http://dis4ea.blogspot.com
No comments:
Post a Comment