April 16, 2008 at 5:00 pm
I have a DB in SQL Server 2005 on one server (Server A). I have another SQL Server 2005 on another server (Server B). I made a .BAK of the DB on Server B. Then, I tried to restore the DB that was on Server A onto Server B. However, I received an error when trying to restore the .BAK:
An exception occurred while executing a Transact-SQL statement or Batch (Microsoft.SQLServer.Express.ConnectionInfo
The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database.
Restore Filelist is terminating abnormally. (MS SQL Server, Error 3169
Both SQL Serves arwe Microsoft SQL Server Management Studio 9.00.3042.00.
What else could be wrong?
April 16, 2008 at 5:12 pm
It sure sounds like the backup is from a later version. Are you sure that both instances are SQL 2005? Maybe you should run RESTORE HEADERONLY with the backup file to see the database version,
Greg
April 16, 2008 at 5:24 pm
I am not really sure. This is what the About boxes say on the SQL Server 2005s.
Server B
Microsoft SQL Server Management Studio Express9.00.3042.00
Microsoft Data Access Components (MDAC)2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML2.6 3.0 5.0 6.0
Microsoft Internet Explorer7.0.5730.11
Microsoft .NET Framework2.0.50727.1433
Operating System5.1.2600
Server A
Microsoft SQL Server Management Studio9.00.3042.00
Microsoft Analysis Services Client Tools2005.090.3042.00
Microsoft Data Access Components (MDAC)2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML2.6 3.0 4.0 6.0
Microsoft Internet Explorer7.0.5730.11
Microsoft .NET Framework2.0.50727.1433
Operating System5.2.3790
April 16, 2008 at 5:29 pm
Run this in a query window on both servers:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Greg
April 16, 2008 at 5:40 pm
One server is: 8.00.2039SP4Personal Edition
The other: 9.00.3054.00SP2Enterprise Edition
I see now. So, they are different.
How can I take a DB in the Enterprise Edition and restore it to the Personal Edition?
April 16, 2008 at 5:57 pm
It's not the edition that's causing the problem. Version 8.00 is SQL Server 2000 and version 9.00 is SQL server 2005. I assume that the backup was made in SQL 2005 and you're trying to restore it in SQL 2000. That can't be done. Backups are not backwards compatible.
Greg
April 16, 2008 at 6:19 pm
I think my confusion is that I have SQL Server 2000 and SQL 2005 on Server. I was logged into the wrong one.
April 16, 2008 at 6:25 pm
I am logged into this server now:
9.00.3042.00SP2Express Edition
The other one is the Enterprise edition. The 2005 is the Express Edition. Will that work?
April 17, 2008 at 2:23 pm
You won't get that error again since you're restoring a 2005 backup on a 2005 instance.
Greg
April 17, 2008 at 2:29 pm
Thanks, I tried this morning and everything worked great. You can tell I am new to SQL 2005. It was kind of confusing to startup of the Management Studio Express and find many different versions/editions. I have 2000 develper, 2000 personal, and Express editions on my PC. Plus, several versions and edition from other servers showing up.
Thanks.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply