restore old database - SQL Server Forums

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 Administration

restore old database

Author

Topic

cognos
Starting Member

10 Posts

Posted - 2011-06-07 : 02:36:50

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...

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

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-06-07 : 02:37:50

duplicate post: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=161492

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources