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 |
|
luoyixin
Starting Member
2 Posts |
 Posted - 2008-12-02 : 17:57:46
|
| Hello.I am a newbie here. Our lab tried to restore a database from sql 7.0 to sql 2005. Could you tell us how to do it step by step? Thanks in advance.peter |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-02 : 18:06:05
|
| Restore 7.0 backup file to SQL Server 2005 with Restore command.See booksonline for it. Certain things won't work in SQL 2005 due to compatibility difference. |
 |
|
|
luoyixin
Starting Member
2 Posts |
Posted - 2008-12-03 : 10:27:06
|
| Restore failed. Error message:3219 |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-12-03 : 11:12:03
|
| Use the Upgrade Advisorhttp://www.dell.com/downloads/global/solutions/public/white_papers/sql2005_upgrade_wp.pdf |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-03 : 11:48:08
|
| Post the command you used. |
|
|
|
|
|
|
restore database from sql 7 to sql 2005