Restore 2005 SQL DB to SQL 2005

Support,

I have a client that recently purchased the SBS 2003 Premium upgrade so that they would have SQL Server 2005 installed for use. They had a gentleman create a DB for them using SQL 2005 Developers Edition. When I try to restore the backup that he created it gives me the following error message:

Error 3169 :
The backed-up database has on-disk structure version 611. The server
supports version 539 and cannot restore or upgrade this database.

After doing several searches around the internet and on Microsofts Support site I see many people who are having this issue trying to restore SQL 2005 DB to SQL 2000, but my issue is not with SQL 2000.

Here are the versions of the SQL 2005 installed on the server:

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML 2.6 3.0 4.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.832
Operating System 5.2.3790

Can someone please help?

Those are the version for your tools. Log onto the SQL Server box and in Management Studio, execute:

select @.@.version

That will give you the version of the database engine. It looks like the tools are SQL Server 2005 but that the engine is SQL Server 2000, SP 4.

-Sue

|||

Yes, 539 was the latest interal version of the datafile strcuture for SQL Server 2000. 611 is the new internal version which came up with SQL Server 2005. If you are getting an error message like this you ARE connecting to a server which only supports 539, so it HAS to be a pre-SQL Server 2005.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Why is it that our database engine would be SQL 2000 SP4, when we just purchased the SBS 2003 Premium Upgrade which comes with SQL 2005.

Also can you please give me the info on upgrading the database engine to SQL 2005, so that I can restore the database backup that the SQL guru has created for our client.

Please help....I am really needing this information so that we can continue forward and begin using this database.

Thanks

|||Hi Aaoron,
As already requested by Sue and Jens can you pls confirm if the db engine pre-sql 2005 ? if yes and if you have a backup of all the dbs you can uninstall it and install sql 2005 and restore the dbs from the backup...............