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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-23 : 07:38:18
|
| David Machine writes "Does anyone know if an SQL2005 database can be backed up and restored on SQL2000 successfully? Am having a problem because at one of my client site we have upgraded their server to 64bit and SQL Server2005 and our development office we have SQL Server2000 now we are having problems trying to restore SQL Server2005 database files to SQL Server2000" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-10-23 : 07:39:32
|
| Can't do it via backup and restore. You'll either need to set up a 2005 server in your office, or use bcp or DTS to export data from their server to files and import them into your system. |
 |
|
|
|
|
|
Backward Compatibility - SQL Server2005 to SQLServer2000