Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 sqlserver restore database

Author  Topic 

cognos
Starting Member

10 Posts

Posted - 2011-06-07 : 02:17:33
i am using sqlserver 2008.i want to restore sqlserver 2005 back up database in sqlserver 2008.i am unable to restore it.it is giving some error.please anyone help me in this...

ddd

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-06-07 : 02:26:55
Can you please specifiy "some error"?


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

cognos
Starting Member

10 Posts

Posted - 2011-06-07 : 02:34:00
TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore failed for Server SQLEXPRESS'. (Microsoft.SqlServer.SmoExtended)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.4000.0+((Katmai_PCU_Main).100916-1939+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The database was backed up on a server running version 7.00.0623. That version is incompatible with this server, which is running version 10.00.4000. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.4000.0+((Katmai_PCU_Main).100916-1939+)&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


ddd
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-06-07 : 02:36:43
Looks like the database backup comes from sql server 7 and not from sql server 2005.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

cognos
Starting Member

10 Posts

Posted - 2011-06-07 : 02:50:08
how can do restore database?

ddd
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-06-07 : 02:57:46
if not mistaken, SQL Server 2008 (100) only support 80 (SQL 2000), 90 (SQL 2005), 100 (SQL 2008).

SQL 2005 should be the last version that support SQL 7.

You need to restore the SQL 7 backup in a SQL Server 2005 and then backup again and restore in SQL 2008.


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-06-07 : 04:25:53
Yup. Absolutely. There's no upgrade path SQL 7 straight to SQL 2008. You'll need to restore the backup either on SQL 2000 or on SQL 2005, change the compatibility level, back it up again and then restore that to SQL 2008.

Be aware that some things may well break if the DB was using features since deprecated.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

cognos
Starting Member

10 Posts

Posted - 2011-06-07 : 05:05:32
Thanks...

ddd
Go to Top of Page
   

- Advertisement -