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 |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2006-02-09 : 03:48:12
|
| Hi,Can I restore a backup of sql server 2000 to sql server 2005?Thanks |
|
|
michaelxvo
Starting Member
47 Posts |
Posted - 2006-02-09 : 10:01:14
|
quote:
Originally posted by penumatsa
I dont think you can do that. If you are planning to move your database to SQL Server 2005, you can do it either by upgrading your database or using DTS to move it to SQL Server 2005.suresh penumatsa
Hey my man, I think you did not check your source before you state something and I am afraid your statement is incorrect. if you check herehttp://msdn2.microsoft.com/en-us/library/ms190436(SQL.90).aspxYES YOU CAN BACKUP FROM SQL SERVER 2000 AND RESTORE TO SQL SERVER 2005 |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-02-09 : 12:29:44
|
| backup/restore of sql2k db to sql2k5 dbms works just fine.-js |
|
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2006-02-09 : 15:20:05
|
| You can't backup 2005 and restore it to 2000. No backward compatibility but the opposite should work fine. |
|
|
|
|
|
|
restore 2000 to 2005