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 |
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
 Posted - 2009-08-31 : 01:42:53
|
| Hi,iam having a back up file taken from sql server 2005.now i want to restore with that back up in 2000.i think it is not possible.but using dts it is achievable?but i dont know how to use that.can you please explain me in using that in sql server 2000 machine. |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-31 : 06:27:13
|
| It is not possible to restore a higher version (2005) database backup to a lower version (2000). The 2000 database engine doesn't/wouldn't know about the metadata changes in future versions.You can use DTS to transfer the database objects from SQL 2005 to SQL 2000, but first you'd need to restore the backup file onto a version of SQL Sever 2005 or higher. |
 |
|
|
|
|
|
data trasnformation services dts