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.
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. |
|
|
cognos
Starting Member
10 Posts |
|
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. |
|
|
cognos
Starting Member
10 Posts |
Posted - 2011-06-07 : 02:50:08
|
how can do restore database?ddd |
|
|
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] |
|
|
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 ShawSQL Server MVP |
|
|
cognos
Starting Member
10 Posts |
Posted - 2011-06-07 : 05:05:32
|
Thanks...ddd |
|
|
|
|
|
|
|